View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
cjakeman cjakeman is offline
external usenet poster
 
Posts: 15
Default 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