MsgBox Prompt Variable

[mharper90]

I'm trying to make the value of a textbox become dynamically inserted into a message box. In the code below, I want NAME replaced with Me.TextBox2.Value.

MsgValue = MsgBox("Are NAME's documents filed?", vbYesNo, "Training Documents")

Thanks!

 

[mikerickson]

Try

MsgValue = MsgBox("Are " & Me.TextBox2.Text & "'s documents filed?", vbYesNo, "Training Documents")

 

[mharper90]

Thanks! I'll give that a try. I basically tried this same thing but without the "&"s. Wish I would have thought of that!