Worksheet_Change Function - Conditions for execution

  • Thread starter Thread starter jbugara
  • Start date Start date
J

jbugara

I am using the worksheet_change event to invoke logic when an updat
occurs to a cell.

I also use the worksheet_beforedoubleclick event to open a form an
allow a user to select from a list of values. My problem is that if
cancel out of the user form, I am placed into the cell where th
doubleclick event was initiated. When I move off the cell, the chang
event occurs even though I have not changed the value of the cell. I
there a way to prevent this from happeing
 
Hi
try adding the line
Cancel = True
in the worksheet_beforedoubleclick event if the user cancels the User
form.

HTH
Frank
 
Back
Top