View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andrew B[_4_] Andrew B[_4_] is offline
external usenet poster
 
Posts: 42
Default Controlling the movement of a drawing object

Hi
I would like to control the placement of a black dot(small circle)on a
spreadsheet page. From the drawing toolbar I can create the dot and by
recording a macro I can see how changing the increment value moves the
object.
e.g. Selection.ShapeRange.IncrementLeft -0.75

I would like to copy the dot and position it exactly using some xy
reference system if that is possible.

Thanks in advance

Andrew Bourke