Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Disable drag and drop and cut and paste SteelDetailer[_2_] Excel Programming 0 June 8th 06 07:59 PM
Change event due to Cut & Paste, Drag & Drop or Edit cjakeman Excel Programming 4 May 28th 06 09:19 AM
Drag and drop event Dantz Excel Programming 2 September 12th 05 11:55 AM
Trig on drag and drop event? Maria J-son Excel Programming 1 July 8th 05 02:30 PM
Can you drag/drop rows w/o using Cut/Paste spp Excel Discussion (Misc queries) 1 March 11th 05 03:05 PM


All times are GMT +1. The time now is 11:55 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"