View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Sizing Autoshapes based on text length

OK I follow your objective. Doable but rather you than me!

Regards,
Peter T

"Nick Hebb" wrote in message
ups.com...
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.