UserForm exiting prior to completion

[Ford_Guy]

The userform I created exits when you press the "ok" button even all the fields are not complete. I know that this is because of where I placed the "unload userform1" command, but I cannot think of how to fix it. I want the first 5 text boxes I have to be mandatory and required to be filled in while the last 2 do not need to be filled in. I will attach the sheet.

Also,

I would like to get rid of the "enable macros" prompt without deleting the modules. How can I do this?

[royUK]

I put code in earlier for you to check if all textboxes were complete

[royUK]

I have amended the earlier code, it checks the textbox's name 7 if it ends in a number below 6 it wont continue

Please Login or Register  to view this content.

[Ford_Guy]

It works fine now. I don't know what went wrong before. Thanks for the help again. However, I do need help getting rid of the enable macros prompt without deleting the modules.

[royUK]

It works fine now. I don't know what went wrong before. Thanks for the help again. However, I do need help getting rid of the enable macros prompt without deleting the modules.

You can't. The UserForm will trigger that on opening. It is a security issue to help prevent malicious code and although there are ways we don't offer solutions to that.