Incorrect info still goes into the sheet from a Userform

[lpekerman]

Hi, another question:

When a user enters the information into the form, even if incorrectly the messages show up and info still gets transfered to the worksheet;
is it possible to get rid of it:
like still in the form say "your info is not entered correctly!" or something?

thanks

 

[fumei]

Yes...it is called error trapping. You can display results of error trapping in a label on the userform. This is quite common actually.

Gerry