| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sizing Autoshapes based on text length
The automatic sizing feature in Autoshape formatting seems buggy to me.
I'm using Excel XP, and when I auto size, it resizes the shape so that all the text is on one line. I would like to keep the width of the shape the same, but adjust the height based on the length of the text. Anyone got any ideas on how I can do this in VBA? Thanks, Nick |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing a column based on the length of text in a cell in anothercolumn | Excel Worksheet Functions | |||
| How to remove text edit from Autoshapes | Excel Discussion (Misc queries) | |||
| How can I export text from excel autoshapes to a text file? | Excel Discussion (Misc queries) | |||
| How do I "conditionally" change font size based on text length? | Excel Programming | |||
| How do you find and replace text in autoshapes or comments | Excel Discussion (Misc queries) | |||
Threaded Mode
