View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default 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