Specify shape dimensions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, can anyone help please.
How can I draw a shape that has specific dimensions.
Steve
 
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
 
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
 
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
 
You must log in or register to reply here.

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

Shape Arrays VBA 0
Function Error 4
PowerPoint Shuffle (swap) objects on PPT slides with the same name only 0
draw shapes in excel using the keyboard 1
Screen vs. Printed Aspect Ratio 1
PowerPoint Super Stuck and Desperately Need Help 0
Powerpoint VBA Issues - Looping through Shapes 0
CURSOR SHAPE HAS CHANGED 3

Back
Top