PDA

View Full Version : Solved: MsgBox "Prompt Message"



jammer6_9
03-17-2008, 07:01 AM
Is it possible to take the msgbox "Prompt Message" to be the value of a textbox in a Userform? :motz2:

Simon Lloyd
03-17-2008, 07:16 AM
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:

Dim MBox as String
MBox = "Prompt Message"
msgbox "MBox"
Textbox1.Value=MBox

jammer6_9
03-17-2008, 07:22 AM
Simon Says:
:thumb :thumb :thumb




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:

Dim MBox as String
MBox = "Prompt Message"
msgbox "MBox"
Textbox1.Value=MBox

mdmackillop
03-17-2008, 06:06 PM
Should it not be msgbox MBox (quotes removed) ?

Simon Lloyd
03-18-2008, 02:18 AM
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!