I am using Office '97 and I have a userform with a number of TextBox
controls. I am using the TextBox's Exit event to check if the data entered
is valid and if it is not valid then I set the Cancel parameter to true to
force the user to enter valid data.
The problem I have is when someone puts invalid data in the textbox then
clicks the cancel button. The problem being that the Exit event of the
textbox still occurs but since the cancel button has been clicked the
invalid data doesn't matter so I don't want to check the validity of the
data.

So, how can I tell if the cancel button has been activated (clicked or Esc
button pushed) from within the Exit event of the Textbox.

Thanks
Fred