View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Nick Hebb Nick Hebb is offline
external usenet poster
 
Posts: 162
Default Sizing Autoshapes based on text length

Not sure I've explained all that very well!

Explanations were perfectly clear.

Unfortunately, nothing is really working well for the non-rectangular
autoshapes like flowchart decision shapes (diamonds). It would be a lot
easier if I could get a handle for the textframe object and determine
it's width. But for now I've had to do mockups for each shape based on
the standard font and make adjustments for different fonts and sizes.
It's gotten fairly convoluted.