Stop Code - Override textbox validation

[03856me]

I have a userform with many textboxes - some of which have requirements to enter valid data or that cannot be left blank. My users have requested a let's say "Master Clear" button that would override all restrictions on the form and allow them to start over, or basically Re-load the form. I am thinking this would work like a CTRL+BREAK but I am not sure how to do this in vba or if it can be done.

My initial thought was this isn't possible because of the enter and exit events, but I don't know what I don't know, so I thought I would ask.

 

[CharlesChuckieCharles]

use EnableEvents to control the firing of event handlers

Application.EnableEvents = False
UserForm1.TextBox1.Value = ""
...
Application.EnableEvents = True

 

[Norie]

Why not change the validation so that it doesn't stop the user leaving the textbox but does something like changing the background colour to red?

As for re-loading the form you would normally use something like this.

Unload Me
 
UserForm1.Show

That wouldn't work if you were stopping the user exit textboxes though.

Another alternative - don't check the data until the user has been through all the textboxes.

Have them click a button that will check the data and move on to the next step only if everything is OK, otherwise highlight all the errors and ask the user to rectifgy them.