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?

The change event occurs when the value property changes. It would not occur
on a tab out unless the value was changed simultaneously.

"dunnerca" wrote:

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?

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

"dunnerca" wrote:

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?