I've been trying to get this to work for hours, but with no luck. I have a userform [UserForm1] which appears on start up of my excel spreadsheet
The userform requires the individual put in their email address and then press a command button to continue
I want a message box to pop up if the email address is blank when the command button is pressed.
So far I can get the message box to appear, but getting it to close is another story.
Since it won't close when I click ok on the message box, I have to exit the spreadsheet entirely (through ctr alt delete) and start again. What am I doing wrong?
This is my code