Ark68
Well-known Member
- Joined
- Mar 23, 2004
- Messages
- 4,564
- Office Version
- 365
- 2016
- Platform
- Windows
I have this code as part of a worksheet change event.
2 Questions:
1) If target value = "- - - - -", it's basically a null value and is an invalid selection from the validation list for the changed cell. How can I return the value back to the original value before "- - - - -" was selected?
2) If the user selects the value (from the validation list available to the user) that is the same that is already there, will the worksheet change event be triggered? If so, how can that be avoided?
Code:
Case Is = 10
'execute procedure4
Stop
MsgBox Target.Value
If Target.Value = "- - - - -" Then
Exit Sub
End If
Stop
MsgBox "Column J: Signature"
2 Questions:
1) If target value = "- - - - -", it's basically a null value and is an invalid selection from the validation list for the changed cell. How can I return the value back to the original value before "- - - - -" was selected?
2) If the user selects the value (from the validation list available to the user) that is the same that is already there, will the worksheet change event be triggered? If so, how can that be avoided?