Hi guys,
I have a userform and sometimes if you don't input a value in one of the textboxes, you get and error.
I want that when there's an error, a messagebox will disply "Please fill in the missing fields" and then go back to the form for the client to continue using it.
I tried:
On Error GoTo ErrMsg
ErrMsg:
MsgBox ("Please fill in the missing fields"), , "Error"
Resume Next
but it just makes the messagebox pop multiple times and you need to press ok several times until it closes.
Any ideas how I can solve this?
Thanks!
I have a userform and sometimes if you don't input a value in one of the textboxes, you get and error.
I want that when there's an error, a messagebox will disply "Please fill in the missing fields" and then go back to the form for the client to continue using it.
I tried:
On Error GoTo ErrMsg
ErrMsg:
MsgBox ("Please fill in the missing fields"), , "Error"
Resume Next
but it just makes the messagebox pop multiple times and you need to press ok several times until it closes.
Any ideas how I can solve this?
Thanks!