msgBox VBA Help needed

[josnow]

Hi!

I would like to write code for a msgbox.

I have created a userform. I would like a msgbox to appear if the user has not entered thier first name into txtFirstName box.

First I would like to confirm that I write this code into the cmdSubmit section.

Secondly I need help to write the code.

This is what I have tried.

If txtFirstName = " " Then
msgbox "Your first name is required" vbcritical, "First Name"
End If

When I do this and click the submit button, no msgbox appears and the form continues to submit.

Thank you so much in advance-Josnow

 

[VoG]

Try

If txtFirstName = "" Then
msgbox "Your first name is required" vbcritical, "First Name"
End If

(no space between "")

 

[Trevor G]

You also need a comma after your message

If txtFirstName = "" Then
msgbox "Your first name is required" vbcritical, "First Name"
End If

Should be

If txtFirstName = "" Then
msgbox "Your first name is required", vbcritical, "First Name"
End If

 

[AD_Taylor]

When I do this and click the submit button, no msgbox appears and the form continues to submit.

I think you may also need to have an 'Exit Sub' in there somewhere to get the form to stop submitting.

So use Trevors as above but add:

 If txtFirstName = "" Then
msgbox "Your first name is required"[COLOR=red],[/COLOR] vbcritical, "First Name"
[COLOR=Red][B]Exit Sub[/B][/COLOR]
End If

 

[josnow]

Hi to you all that replied. Just wanted to say a really BIG THANKYOU form the bottom of my heart. I do hope you come back to read this because I am so grateful.

This is what I ended up writing and thank to you all it works!!(smilin')

If txtFName = "" Then
MsgBox "Your first name is required", vbCritical, "First Name"
Exit Sub
ElseIf txtFName = True Then
Range("firstName").Value = txtFName.Text
End If

josnow