MsgBox prompt to include TextBox4 value?

[Big Lar]

If Trim(Me.TextBox4.Value) >= 7 Then<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>
If MsgBox(Prompt:="Is #1 score correct?", Buttons:=vbYesNo) = vbNo Then<o:p></o:p>
Me.TextBox4.SetFocus<o:p></o:p>
Exit Sub<o:p></o:p>
Else<o:p></o:p>
End If<o:p></o:p>
End If

<o></o>
Is it possible for the MsgBox prompt to include TextBox4 value?
<o></o>
Example:
<o></o>
If TextBox4.Value equals 10,
<o></o>
MsgBox prompt equals “Is 10 correct for #1?”

 

[VoG]

Try

If MsgBox(Prompt:="Is " & TextBox4.Value & " correct for #1?", Buttons:=vbYesNo + vbQuestion) = vbNo Then

 

[bjurney]

I belive this is what you are looking for

If Trim(Me.TextBox4.Value) >= 7 Then
If MsgBox(Prompt:="Is " & Trim(Me.TextBox4.Value) & " correct for #1?", Buttons:=vbYesNo) = vbNo Then
Me.TextBox4.SetFocus
Exit Sub
Else
End If
End If

 

[bjurney]

Leave it to an MVP to beat me to it!

 

[VoG]

Leave it to an MVP to beat me to it!

We do our best

Also, since Text Boxes store values as text (!) I think that you need

If Val(Trim(Me.TextBox4.Value)) >= 7 Then

to convert to a number.

 

[Big Lar]

Thanks y'all. Works zackly like I wanted.