Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
probably a quick and easy question but I cannot seem to figure it out. here
goes I have a button that inserts a copy of a shape into the active cell when clicked. what I want to do is delete the existing shape if one exists (in that activecell) and paste in the new one. here is my code. thanks for any help. much appreciated. Private Sub CommandButton2_Click() 'check for existing shape in activecell - If one exists then delete, if not continue ActiveSheet.Shapes("Picture 1").Select Selection.Copy ActiveCell.Select ActiveSheet.Paste Selection.ShapeRange.IncrementTop 10 Selection.ShapeRange.IncrementLeft -2 ActiveCell.Value = 1 ActiveCell.Next.Select End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Check for a shape - then change or delete it if it exists | Excel Programming | |||
my curser changed from arrow shape to a cross shape???? | New Users to Excel | |||
Why can't I delete this shape now? | Excel Programming | |||
Deleting a shape and the cell contents the shape is in. | Excel Programming | |||
Deleting a shape and the cell contents the shape is in. | Excel Programming |