| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Specify shape dimensions
Hi, can anyone help please.
How can I draw a shape that has specific dimensions. Steve |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Specify shape dimensions
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 "SteveT" wrote: Hi, can anyone help please. How can I draw a shape that has specific dimensions. Steve |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Specify shape dimensions
Thanks Chuck,
I will look into that, Kind regards, Steve "CLR" wrote: 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 "SteveT" wrote: Hi, can anyone help please. How can I draw a shape that has specific dimensions. Steve |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Specify shape dimensions
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 "SteveT" wrote: Thanks Chuck, I will look into that, Kind regards, Steve "CLR" wrote: 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 "SteveT" wrote: Hi, can anyone help please. How can I draw a shape that has specific dimensions. Steve |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Specify shape dimensions
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 "JakeA" wrote: 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 "SteveT" wrote: Thanks Chuck, I will look into that, Kind regards, Steve "CLR" wrote: 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 "SteveT" wrote: Hi, can anyone help please. How can I draw a shape that has specific dimensions. Steve |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format Cells - Architectural Dimensions | Excel Discussion (Misc queries) | |||
| keeping a shape constant regardless of changes in variables | Excel Discussion (Misc queries) | |||
| How do I change the default shape for comments in Excel? | Excel Worksheet Functions | |||
| Blue diamond shape in a cell | Excel Discussion (Misc queries) | |||
| Capturing Shape Name/Text from OnAction property | Excel Discussion (Misc queries) | |||
Hybrid Mode
