Solved: MsgBox "Prompt Message"

[jammer6_9]

Is it possible to take the msgbox "Prompt Message" to be the value of a textbox in a Userform?

[Simon Lloyd]

It seems like coding you don't need to do as you already have to pass the variable to the msgbox so why not pass it directly to the textbox? but you could do something like:
[VBA]
Dim MBox as String
MBox = "Prompt Message"
msgbox "MBox"
Textbox1.Value=MBox
[/VBA]

[jammer6_9]

Simon Says:

It seems like coding you don't need to do as you already have to pass the variable to the msgbox so why not pass it directly to the textbox? but you could do something like:
[vba]
Dim MBox as String
MBox = "Prompt Message"
msgbox "MBox"
Textbox1.Value=MBox
[/vba]

[mdmackillop]

Should it not be msgbox MBox (quotes removed) ?

[Simon Lloyd]

Lol! Malcom thanks! thats what you get for not paying attention to what you are writing!, but there again jammer should have noticed my faux pas when he ran the code!