Autoshapes - placing on screen

  • Thread starter Thread starter John Phillips
  • Start date Start date
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
 
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)
 
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
 
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)
 
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
 
Back
Top