Text Box Change Event

[dunnerca]

I'm coding a userform text box change event. I want a msgbox to come up if
the user changes the cell contents but the msgbox comes up if the new
contents are different from the old contents; however, if the user just tabs
out of the text box the msgbox comes up (i.e. - the program sees that as a
"change" event.

Does the "change" refer to a change in focus or a change in the contents?

 

[JLGWhiz]

The change event occurs when the value property changes. It would not occur

 

[Jim May]

Always post your existing code - FOR THE BEST ANSWER (Results).