Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting a shape and the cell contents the shape is in.
You could check to see what's selected with:
typename(selection) Option Explicit Sub testme() MsgBox TypeName(Selection) Select Case TypeName(Selection) Case Is = "Range" 'cell is selected, do that Case Else Selection.TopLeftCell.ClearContents Selection.Delete End Select End Sub I put some circles/ellipses in some cells and ran the macro. Typename returned Oval. You could check for each type that you're using or just quit if it's not a range (force them to be more careful). John DeFiore wrote: Someone here was kind enough to show me how to delete a shape that's in the active cell, along with the cell contents. This is for a macro that's attached to a button. The user clicks a cell, then that cell and the shape (basically a dot) in the cell is deleted. No problem, unless instead of clicking the cell, the user clicks in the dot in the cell and selects IT instead of activating the cell. Unhappiness. How would I first delete any selected shape and the contents of the cell in which it is (entirely) located? I could then be sure I had both cases covered and the macro would always work. Thanks, John -- Dave Peterson |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting a shape and the cell contents the shape is in.
Thanks for the reply, Dave.
Regards, John -----Original Message----- You could check to see what's selected with: typename(selection) Option Explicit Sub testme() MsgBox TypeName(Selection) Select Case TypeName(Selection) Case Is = "Range" 'cell is selected, do that Case Else Selection.TopLeftCell.ClearContents Selection.Delete End Select End Sub I put some circles/ellipses in some cells and ran the macro. Typename returned Oval. You could check for each type that you're using or just quit if it's not a range (force them to be more careful). John DeFiore wrote: Someone here was kind enough to show me how to delete a shape that's in the active cell, along with the cell contents. This is for a macro that's attached to a button. The user clicks a cell, then that cell and the shape (basically a dot) in the cell is deleted. No problem, unless instead of clicking the cell, the user clicks in the dot in the cell and selects IT instead of activating the cell. Unhappiness. How would I first delete any selected shape and the contents of the cell in which it is (entirely) located? I could then be sure I had both cases covered and the macro would always work. Thanks, John -- Dave Peterson . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i link shape to a cell in excel | Excel Discussion (Misc queries) | |||
Make a cell display the contents of a shape | Excel Worksheet Functions | |||
Format Shape, will not move accordingly, when deleting columns | Excel Discussion (Misc queries) | |||
my curser changed from arrow shape to a cross shape???? | New Users to Excel | |||
Blue diamond shape in a cell | Excel Discussion (Misc queries) |