| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text box physical string length
Is there an easy way to get the length of a string (inches
or points) going into a text box before the AddTextbox call? I'm trying to center text at the centroid of closed polylines - lots of them. Figuring character width as ~60% of the font size seems to be a hit or miss thing. Maybe I could use Autosize and get the textbox length with the AddTextbox call, but I'm finding it's slow. It would likely be faster to figure it character by character once the width vs character code is worked out. Evan Weiner Richland WA |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fixed length string of text | Excel Discussion (Misc queries) | |||
| length of text string goes beyond cells are not visible | Excel Discussion (Misc queries) | |||
| Limiting physical length of text in a text box control | Excel Discussion (Misc queries) | |||
| want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
| want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
Threaded Mode
