Specify shape dimensions

S

SteveT

Hi, can anyone help please.
How can I draw a shape that has specific dimensions.
Steve
 
C

CLR

Some basic shapes can be drawn and located with VBA, parametrically or by
hard code. I know of no other way to draw shapes to specific dimensions.

hth
Vaya con Dios,
Chuck, CABGx3
 
J

JakeA

Glad to know there is a way, although I am not that good at VBA. I was sad
to learn that the dimension feature for shapes in Excel 97 had been removed
the 2007 version. I depended on it a lot for various tasks.

JakeA
 
J

JakeA

Oops! Just discovered where they moved it to. Thought it was gone.

Make a shape, select it. Right click for menu and select "Size &
Properties...". Type your dimensions in the value boxes.

JakeA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove dimension text from shape 0
Visio: copy text of a master shape to User-define Cells (Variable) 0
Size & Position precision 0
Filtered view of Visio Chart 0
Visio to Excel 0
Photo rotation within a shape - Microsoft 2013 0
Shape Fill Help 3
Adding connection points to shapes manually/programmatically 0

Top