MsgBox to include Textbox value???

[Big Lar]

I'm using this to display a Message Box

[FONT=Verdana]If Trim(Me.TextBox10.Value) <> 0 Then<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>[/FONT]
[FONT=Verdana]If MsgBox(Prompt:="Cash is out of balance. Accept?", Buttons:=vbYesNo) = vbNo Then<o:p></o:p>[/FONT]
[FONT=Verdana]Exit Sub<o:p></o:p>[/FONT]
[FONT=Verdana]Else<o:p></o:p>[/FONT]
[FONT=Verdana]End If<o:p></o:p>[/FONT]
[FONT=Verdana]End If<o:p></o:p>[/FONT]
[FONT=Verdana]<o:p>[/FONT]

</o>
<o></o>
Can I code the MsgBox prompt to include the value of Textbox10? <o></o>
<o></o>
So if TextBox10 value is 4, the MsgBox prompt would read “Cash is out of balance by $4. Accept?”<o></o>

 

[JamesW]

Hi,

Try this:

[FONT=Verdana]If MsgBox(Prompt:="Cash is out of balance by $" & Textbox10.Value & ". Accept?", Buttons:=vbYesNo) = vbNo Then[/FONT]

 

[Big Lar]

Thanks JamesW.

I had it except for the "&"
It's those little things...huh?