Prompt to complete form before exiting user form

[VBAmalta89]

I have a user form and I need all the available fields available in the user form to have data inputted in them before the user can click on a button to confirm and exit.

How do I program this in VBA?

 

[Andrew Poulsom]

What sort of controls do you have on your UserForm and what are their names? You will have to check each one.

 

[VBAmalta89]

the user form consists of a series of text boxes where the user is asked to input values.

For example, I have text boxes called AreaShop and ZoneNum which must be filled before exiting the user form.

 

[Andrew Poulsom]

Test that the controls don't contain null in your button click event procedure. If they do, use MsgBox to inform the user and exit the Sub.

 

[VBAmalta89]

Ok I managed thanks for your help with this issue