Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Entering variables on Msgbox prompt
Hi, I am trying to enter a variable on the prompt of a message box. Could someone help me on this? Thanks, Variable: Range("Year") Prompt: Msgbox "Yada yada yada (variable should go here) yada yada yada" -- renegan ------------------------------------------------------------------------ renegan's Profile: http://www.excelforum.com/member.php...o&userid=10450 View this thread: http://www.excelforum.com/showthread...hreadid=498001 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Entering variables on Msgbox prompt
Hi renegan
Dim a as variant a = Range(???).value Msgbox "Yada yada yada " & a & " yada yada" Regards Yngve |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Entering variables on Msgbox prompt
Assuming the result is a string you could use something like:
Dim sYear As String sYear = Range("Year").Value Msgbox "Yada yada yada " & sYear & " yada yada yada" Best regards John "renegan" wrote in message ... Hi, I am trying to enter a variable on the prompt of a message box. Could someone help me on this? Thanks, Variable: Range("Year") Prompt: Msgbox "Yada yada yada (variable should go here) yada yada yada" -- renegan ------------------------------------------------------------------------ renegan's Profile: http://www.excelforum.com/member.php...o&userid=10450 View this thread: http://www.excelforum.com/showthread...hreadid=498001 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Entering variables on Msgbox prompt
Thank you both John and evgny. It worked fine. -- renegan ------------------------------------------------------------------------ renegan's Profile: http://www.excelforum.com/member.php...o&userid=10450 View this thread: http://www.excelforum.com/showthread...hreadid=498001 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VB - ignore a msgbox prompt | Excel Discussion (Misc queries) | |||
How do I format a MSGBOX to show text and variables in a macro? | New Users to Excel | |||
Line breaks in MsgBox concatenated variables | Excel Programming | |||
Msgbox prompt and tabbing | Excel Programming | |||
msgbox prompt when user selects data from combo box | Excel Programming |