How to make a message box pop up in user form
Hello All I am new at VBA and built a user form in excel 2010 I am trying to get a message to pop up every time the end user leaves a field blank so in other words I have 32 fields- the first two fields are called first name and last name so lets say the end user puts in the first name but leaves the last name blank I want a message to pop up saying "Did you mean to leave blank". Any help is greatly appreciated please
Thank you
Something like this incorporated into your SUBMIT button would check all the textboxes and give an appropriate message.
This presumes you are filling in the TAG property for each textbox so the macro can use the TAG as part of the message.
Please Login or Register to view this content.
Last edited by JBeaucaire; 01-08-2016 at 12:08 PM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
I am not really sure what that means but below is my code I have a command to update and add and go to next record in the userform I just want to add a code where a message box pops up if the end user leaves a field blank. Sorry I know I seem like I am asking dumb question but again I am a newbie at vba its a whole different world for me.
Please Login or Register to view this content.
Last edited by cardonas; 01-08-2016 at 01:25 AM.
The code I provided would go at the top of your UpdateForm macro. (the part in red)
Ok so I put the code below but I get an error and when I debug it outlines the Sub field
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks