MsgBox appearing when not wanted

[Noz2k]

I have this code on the first textbox on a userform

Private Sub Textbox1_AfterUpdate()
If Not Textbox1.Value Like "*[ ]*" Then
MsgBox "Must include both First & Second Name"
Cancel = True
Textbox1.SetFocus
End If
End Sub

The problem I am having is because the focus is set to begin in this textbox after I send a record to excel, it generates the msgbox before the user has a chance to enter any data.

The same thing happens if the user clicks the little x in the corner of the form if the cursor is in this textbox at the time.

Is there a way to prevent this from happening?

 

[Norie]

Well I think the logic place to put the check for a future date would be after you've checked it is a date.

 

[Noz2k]

Yeah, I have now added it to the exit event.

It just bothers me that it tells the user it is correct until they exit that textbox. But nevermind, can't be perfect I guess.

Thanks for all your help

 

[Norie]

Sorry I don't understand, can you post your code?

Are you actually showing a message saying it's correct?

Do you want to monitor every change in the textbox to make sure its OK?

 

[Noz2k]

Don't worry Norie, what I have now works well enough.

Thanks for your help