Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change event due to Cut & Paste, Drag & Drop or Edit
Hi,
Just a follow-up to a previous thread of the same name which has now expired (http://groups.google.com/group/micro...6d434398fc0f1d) That thread was about using the Worksheet_Change and Worksheet_SelectionChange events to respond to a user's edits. It reliably tells the difference between an add, an edit, a "cut and paste" and a "drag and drop". I now have a generic and tested routine which is packaged into a module that anyone can use without change. It handles edits to single cells (including merged ones) but not yet for multiple cells. Thanks to this routine, my Excel application to help schedule classes for a college department is working well. Feel free to email me about any of this if it might be useful. Bye for now, Chris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disable drag and drop and cut and paste | Excel Programming | |||
Change event due to Cut & Paste, Drag & Drop or Edit | Excel Programming | |||
Drag and drop event | Excel Programming | |||
Trig on drag and drop event? | Excel Programming | |||
Can you drag/drop rows w/o using Cut/Paste | Excel Discussion (Misc queries) |