How to make a text box mandatory?

[hypuk]

Hi guys

How do I make a text box mandatory, so if the user clicks or tabs on to the next field it fires a error message?

Any help would be much appreciated

Thanks
Mark

[Bob Phillips]

Look at the Exit method of the TextBox.

[hypuk]

Hi there

I'm new to VBA so I don't understand what you're talking about

Thanks
Mark

[Bob Phillips]

Do you know how to create a userform and assign events to controls?

[hypuk]

Hi There

I've found out how to do it now

Thanks
Mark

[JP2112]

This might not be the answer you're looking for, but it's better to check for missing fields at the end of the data entry process, instead of interrupting the user every time they skip a field. Not every user fills out the same form the same way.

For example, the code behind a Submit button that writes fields in your form to a database could check if all required fields are filled, and pop up a message box at that time.