Scale in a Title Block

I was working on creating a blog about Title Blocks, but I got sidetracked on creating a Size Block element for the Title Block.

As with most blogs I started with a little research and came across these two blogs from some Visio experts.

https://bvisual.net/2017/07/10/the-different-drawing-scale-shapes-in-visio/

http://www.visguy.com/2017/11/19/detect-drawing-units-in-the-shapesheet/

So it seemed obvious that I needed to do an Insert Field

That was a good start, but that only gave the value. I wanted the units as well. Rereading Chris’s post made me realize I need to let “Insert Field” know I want to treat the value as a string. The easiest way is to concatenate a string to it. Chris used an empty string, but since I wanted to include an ” = ” and the DrawingScale I tried.

What I was hoping for was to be able to use the fractions as in the Page Setup dialog, but I got decimals and a single quote and double quote for feet and inches.

Actually, with a little playing around I came up with the following custom formulas…

I still need to play with the denominator. “#/#” will create a fraction and I can set the denominator # to a value, but what should that value be? 1/2, 3/4 and 1/32 all have different denominators.

When I was initially stuck with no units, I noticed Insert Field included User cells, so, I considered adding User cells to the Pagesheet and reference those cells.

Value
Formula

Luckily I did crack the Formatting secret and the VBA solution was not needed. The VBA solution may be a bit much for the average user, most do not turn on VBA or know anything about it.

I also found that Chris AKA Visio Guy, had created a great set of posts on Title Blocks that mirror what I was basically going to publish, so I will limit my blog on Title Blocks to embellishments to what Chris has posted.

His Title Block blog posts are….

http://www.visguy.com/2008/10/21/title-blocks-1-how-to-display-existing-document-information/

http://www.visguy.com/2008/11/19/title-block-2-lets-make-a-multi-field-smartshape/

http://www.visguy.com/2009/01/23/title-block-3-smart-tabs-smart-text/

I hope this helps.

John… Visio MVP in x-aisle
JohnVisioMVP.ca

Published by johnvisiomvp

The original Visio MVP. I have worked with the Visio team since 1993

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s