Input Box and Message box Help

[Guest]

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

 

[Bob Phillips]

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"

 

[Guest]

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

 

[mpeplow]

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