What Ref Edit event shoots After User Completed the selection?

[19411945]

Hello,
What Event do I use with RefEdit control that shoots after user have made the selection on the spreadssheet and released the mouse button? I tried using onchange() event, but it shoots each time I include new cell in the selection.
I would very appreciate if you help me.
Thank you.

 

[MeGustaXL]

Hi There 19411945 - Interesting name!

I think it's the BeforeDragOver() event, but I'm sorry I haven't worked out how to trap and use it properly myself.
HTH

Chris

 

[SkipVought]

Hi,

I don't know what problem you are having with the Worksheet_SelectionChange event? With or without a Userform, this event fires AFTER the user completes a range selection change (ie releases the left-mouse button)

???

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com