I want to size a shape based upon the text contained with the shape...and do this via Excel 2007 VBA.
Say I have a rectangle shape that is 40 pixels wide and 40 pixels high with a single line of text inside of it that would go beyond the end of the shape. I want to resize the height of the shape to accomodate the all the text. Say maybe the new rectangle might be 80 pixel high by 40 pixel wide.
Bookmarks