ExcelBanter - Width properties of drawing objects

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Width properties of drawing objects (https://www.excelbanter.com/excel-programming/319453-width-properties-drawing-objects.html)

Mark[_50_]

Width properties of drawing objects

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

Sharad

Width properties of drawing objects

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!

All times are GMT +1. The time now is 06:13 AM.