I am using excel 97 and want to pick up the width of a drawing object but
cannot find the appropriate code that will work.

I have tried something like this:

Dim BoxWidth as single

BoxWidth = Sheets("Control").DrawingObjects("TopBox").Width

Can anyone point me in the right direction, please?


Regards

--
Mark A Whitehead

Tyr Shapes instead of DrawingObjects. eg:
BoxWidth = Sheets("Control").Shapes("TopBox").Width

Sharad

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!