Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.interopoledde,microsoft.public.excel.programming
|
|||
|
|||
Events for cell deletion
Are any events raised when cells are deleted?
I have just tested in Excel, and I seem to get a Workbook_SheetChange event, and I expect the Worksheet_SheetChange and Worksheet_Change events work as well. The problem is that I can't find any information about what the arguments mean when cells are being deleted. Thanks, Aaron Queenan. |
#2
Posted to microsoft.public.excel.interopoledde,microsoft.public.excel.programming
|
|||
|
|||
Events for cell deletion
Aaron
Deleted as in Cleared Contents? If so, you can check whether the target (the cell that was changed) is empty. Like this Private Sub Worksheet_Change(ByVal Target As Range) If IsEmpty(Target) Then MsgBox "cell was deleted" End If End Sub -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. "Aaron Queenan" wrote in message ... Are any events raised when cells are deleted? I have just tested in Excel, and I seem to get a Workbook_SheetChange event, and I expect the Worksheet_SheetChange and Worksheet_Change events work as well. The problem is that I can't find any information about what the arguments mean when cells are being deleted. Thanks, Aaron Queenan. |
#3
Posted to microsoft.public.excel.interopoledde,microsoft.public.excel.programming
|
|||
|
|||
Events for cell deletion
I mean when right-clicking on a cell/range/row/column and selecting
"Delete...". That way it shifts the other cells/rows/columns closer to the top left, but unfortunately it only gives a Change event containing the new data in the range, which is pretty useless because I want to find out the cells which were removed in the process. :-( Is there any other event I can listen to or property I can check to find out what was in the removed cells? Thanks, Aaron. "Dick Kusleika" wrote in message ... Aaron Deleted as in Cleared Contents? If so, you can check whether the target (the cell that was changed) is empty. Like this Private Sub Worksheet_Change(ByVal Target As Range) If IsEmpty(Target) Then MsgBox "cell was deleted" End If End Sub -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. "Aaron Queenan" wrote in message ... Are any events raised when cells are deleted? I have just tested in Excel, and I seem to get a Workbook_SheetChange event, and I expect the Worksheet_SheetChange and Worksheet_Change events work as well. The problem is that I can't find any information about what the arguments mean when cells are being deleted. Thanks, Aaron Queenan. |
#4
Posted to microsoft.public.excel.interopoledde,microsoft.public.excel.programming
|
|||
|
|||
Events for cell deletion
Aaron
Unfortunately, no. One option would be to replace the Delete commandbarbutton with your own macro that copies the cells, then does the normal delete. You would have to change three toolbars, namely the Cells, Row and Column commandbars. Post back if that's something you want to try and need help with it. -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. "Aaron Queenan" wrote in message ... I mean when right-clicking on a cell/range/row/column and selecting "Delete...". That way it shifts the other cells/rows/columns closer to the top left, but unfortunately it only gives a Change event containing the new data in the range, which is pretty useless because I want to find out the cells which were removed in the process. :-( Is there any other event I can listen to or property I can check to find out what was in the removed cells? Thanks, Aaron. "Dick Kusleika" wrote in message ... Aaron Deleted as in Cleared Contents? If so, you can check whether the target (the cell that was changed) is empty. Like this Private Sub Worksheet_Change(ByVal Target As Range) If IsEmpty(Target) Then MsgBox "cell was deleted" End If End Sub -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. "Aaron Queenan" wrote in message ... Are any events raised when cells are deleted? I have just tested in Excel, and I seem to get a Workbook_SheetChange event, and I expect the Worksheet_SheetChange and Worksheet_Change events work as well. The problem is that I can't find any information about what the arguments mean when cells are being deleted. Thanks, Aaron Queenan. |
#5
Posted to microsoft.public.excel.interopoledde,microsoft.public.excel.programming,microsoft.public.excel.sdk
|
|||
|
|||
Events for cell deletion
Thanks, Dick.
Unfortunately, we need a way that will work regardless of whether the user or a program initiates the command. Is it possible to listen for commands using the Excel 97 SDK, i.e. to query Excel for the command handler, then replace it with my own? Thanks, Aaron Queenan. "Dick Kusleika" wrote in message ... Aaron Unfortunately, no. One option would be to replace the Delete commandbarbutton with your own macro that copies the cells, then does the normal delete. You would have to change three toolbars, namely the Cells, Row and Column commandbars. Post back if that's something you want to try and need help with it. -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. "Aaron Queenan" wrote in message ... I mean when right-clicking on a cell/range/row/column and selecting "Delete...". That way it shifts the other cells/rows/columns closer to the top left, but unfortunately it only gives a Change event containing the new data in the range, which is pretty useless because I want to find out the cells which were removed in the process. :-( Is there any other event I can listen to or property I can check to find out what was in the removed cells? Thanks, Aaron. "Dick Kusleika" wrote in message ... Aaron Deleted as in Cleared Contents? If so, you can check whether the target (the cell that was changed) is empty. Like this Private Sub Worksheet_Change(ByVal Target As Range) If IsEmpty(Target) Then MsgBox "cell was deleted" End If End Sub -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. "Aaron Queenan" wrote in message ... Are any events raised when cells are deleted? I have just tested in Excel, and I seem to get a Workbook_SheetChange event, and I expect the Worksheet_SheetChange and Worksheet_Change events work as well. The problem is that I can't find any information about what the arguments mean when cells are being deleted. Thanks, Aaron Queenan. |
#6
Posted to microsoft.public.excel.interopoledde,microsoft.public.excel.programming,microsoft.public.excel.sdk
|
|||
|
|||
Events for cell deletion
Aaron
I don't know, but I doubt it. -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. "Aaron Queenan" wrote in message ... Thanks, Dick. Unfortunately, we need a way that will work regardless of whether the user or a program initiates the command. Is it possible to listen for commands using the Excel 97 SDK, i.e. to query Excel for the command handler, then replace it with my own? Thanks, Aaron Queenan. "Dick Kusleika" wrote in message ... Aaron Unfortunately, no. One option would be to replace the Delete commandbarbutton with your own macro that copies the cells, then does the normal delete. You would have to change three toolbars, namely the Cells, Row and Column commandbars. Post back if that's something you want to try and need help with it. -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. "Aaron Queenan" wrote in message ... I mean when right-clicking on a cell/range/row/column and selecting "Delete...". That way it shifts the other cells/rows/columns closer to the top left, but unfortunately it only gives a Change event containing the new data in the range, which is pretty useless because I want to find out the cells which were removed in the process. :-( Is there any other event I can listen to or property I can check to find out what was in the removed cells? Thanks, Aaron. "Dick Kusleika" wrote in message ... Aaron Deleted as in Cleared Contents? If so, you can check whether the target (the cell that was changed) is empty. Like this Private Sub Worksheet_Change(ByVal Target As Range) If IsEmpty(Target) Then MsgBox "cell was deleted" End If End Sub -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. "Aaron Queenan" wrote in message ... Are any events raised when cells are deleted? I have just tested in Excel, and I seem to get a Workbook_SheetChange event, and I expect the Worksheet_SheetChange and Worksheet_Change events work as well. The problem is that I can't find any information about what the arguments mean when cells are being deleted. Thanks, Aaron Queenan. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Deletion | Excel Discussion (Misc queries) | |||
Restrict cell deletion | Excel Discussion (Misc queries) | |||
Cell filter deletion | Excel Discussion (Misc queries) | |||
Prompt Before Cell Deletion | New Users to Excel | |||
#REF! after cell deletion | Excel Discussion (Misc queries) |