I have a user form and I need the fields to be required to be filled before it can be closed. Right now I have. . .
I would like everything before Cells . . = X to be required before it can be closed. How is this done? Thank you!
Please Login or Register to view this content.
Last edited by hhpack3; 07-02-2014 at 09:38 AM.
Please Login or Register to view this content.
Last edited by Speshul; 07-01-2014 at 04:16 PM.
Im not exactly sure how to use that code you just put up.
Try this? Not sure if it's exactly what you need but you should see what I'm getting at
Edit: Didn't realize they were all variables thought they were textboxes for some reason, make sub Public? I'm actually no good with VBA, I've just put code under this event before..
(Also make sure you replace UserForm in the first line with your forms name)Please Login or Register to view this content.
Last edited by Speshul; 07-01-2014 at 04:28 PM.
I tweaked it a little but now it works! Thank You!
No problem, learning experience for me as well
Make sure you mark as [SOLVED] if this issue is now resolved!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks