Autoshapes - placing on screen

J

John Phillips

Hi All

Is it possible to draw an Autoshape (say a rectangle) in a
worksheet at a particular place on a screen. That is, to
position it on screen using coord's rather than 'by
hand' ??

Thanks
John P
 
B

Bob Phillips

Hi John,

It doesn't mater what shape, as they are part of a shapes collection which
you can address.

Here is an example

With ActiveSheet.Shapes("shpBob")
.Left = 500
.Top = 555
End With

where shpBob is the shape name, whiich you can set.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
J

John Phillips

Hi Bob

Thanks for the reply. Next question ....
How would I use this if I need to draw a series of
rectangles on screen, each referenced from a table of
values that define the x,y coord of the four corners ??

I have investiagted using an x-y scatter graph, but can
only draw one rectangle at a time this way (besides I
don't really want to use a chart)

Many thanks for your help
John P
 
B

Bob Phillips

John,

Are you still seeking an answer for this?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
J

John Phillips

Hi Bob

Yep, be useful if I could do it. Basically, I have a large
data table with each line defining the four corners of a
rectangle. The data may change from time to time and I
need to redraw all the rectangles. At present I'm doing
this 'by hand' but I'm sure there must be a
quicker'n'slicker way of doing it.

Hope this makes sense. Very grateful for your help.

Regards
John P
 
Top