View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Horatio J. Bilge, Jr. Horatio J. Bilge, Jr. is offline
external usenet poster
 
Posts: 135
Default Position drawing object relative to cell

I am trying to work out how to position an oval over a cell. On frmOval, if
the user selects a certain radio button, I want an oval to appear over a
specified cell.

I drew an oval of the correct size, and I would like to copy and paste it to
the correct spot. This is what I got from the Macro recorder, by copying,
pasting, and moving it into position. It seems clunky, and I'm wondering if
there is an easier way to specify the position relative to the cell. There
are 11 possible cell positions, based on 11 radio buttons.

If Me.optOval01.Value = True Then
ActiveSheet.Shapes("Oval 11").Select
Selection.Copy
ActiveSheet.Paste
Selection.ShapeRange.IncrementLeft -12#
Selection.ShapeRange.IncrementTop 18#
End If