Input Box and Message box Help
 

I have an input box that a person enters there name into.
Name = InputBox("Please Enter you Full Name")

Later in the program i need to have a message box pop up that asks the user
if they are ready to calculate the data. I would like the msgbox to display
the user's name

Such as, this is of course not right

Msgbox(Name "Are you ready to calculate the data?")
So if Name = Kevin
the MsgBox would say Kevin are you ready to calculate the data?

Thanks for the help

Input Box and Message box Help
 

ans = MsgBox(Name & " are you ready to calculate the data?")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Lost and Looking for Help"
wrote in message
...
I have an input box that a person enters there name into.
Name = InputBox("Please Enter you Full Name")

Later in the program i need to have a message box pop up that asks the
user
if they are ready to calculate the data. I would like the msgbox to
display
the user's name

Such as, this is of course not right

Msgbox(Name "Are you ready to calculate the data?")
So if Name = Kevin
the MsgBox would say Kevin are you ready to calculate the data?

Thanks for the help

Input Box and Message box Help
 

Sub PromptMe()
Dim Name As String
Name = InputBox("Please enter your name", "Enter Name")
MsgBox Name & ", are you ready to calculate the data?"
End Sub


"Lost and Looking for Help" wrote:

I have an input box that a person enters there name into.
Name = InputBox("Please Enter you Full Name")

Later in the program i need to have a message box pop up that asks the user
if they are ready to calculate the data. I would like the msgbox to display
the user's name

Such as, this is of course not right

Msgbox(Name "Are you ready to calculate the data?")
So if Name = Kevin
the MsgBox would say Kevin are you ready to calculate the data?

Thanks for the help

Input Box and Message box Help
 

intReturn = MsgBox(Name & "Are you ready to calculate the data?",
vbYesNo)
Select Case intReturn
Case vbYes
'What to do if yes
Case vbNo
'What to do if no
End Select


--
mpeplow
------------------------------------------------------------------------
mpeplow's Profile: http://www.excelforum.com/member.php...o&userid=34812
View this thread: http://www.excelforum.com/showthread...hreadid=551941