Posted to microsoft.public.excel.programming

Mark[_50_] Mark[_50_] is offline

external usenet poster

Posts: 15

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Group drawing objects in VBA	Bubb	Excel Discussion (Misc queries)	2	April 10th 06 04:22 PM
Cutting Drawing Objects	LostNFound	Excel Discussion (Misc queries)	3	August 12th 05 05:35 PM
HOW DO I KEEP DRAWING OBJECTS ANCHORED?	HOW DO I KEEP DRAWING OBJECTS ANCHORED?	Excel Discussion (Misc queries)	1	May 20th 05 01:35 PM
[Q] parameters to drawing objects	Rolf Marvin Bøe Lindgren	Excel Programming	1	May 12th 04 10:20 AM
conditional formatting to drawing objects.	borde	Excel Programming	1	January 24th 04 04:23 AM

All times are GMT +1. The time now is 08:22 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us