Dont Allow Empty Userform Fields

Originally Posted by Adam Hewitt

I dont think that this is right for me.

The code that i have works but only for one field. I dont know how to make it work for multiple fields.

Why it loops through controls & checks if they are complete. You can set the CommandButton's Visible or preferably Enabled Property according to the Function results