How to resize any shape in excel

Hi All,

I need excel macro for resize any shape in excel.

i.e. By editing text in any cell should replicate to the shape and the shape should resize itself according to the number of texts.

Help me on this !

Thanks in advance !

Here is some code;

Please Login or Register  to view this content.

Don't know if this is what you were looking for?

LeapingLizard