Prev: CONCATENATE by criteria and range
Next: Locked Cells
From: JakeA on 26 Apr 2010 16:20
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
From: JakeA on 26 Apr 2010 16:41
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
 | 
Pages: 1
Prev: CONCATENATE by criteria and range
Next: Locked Cells