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

Entering variables on Msgbox prompt
 

Hi renegan
Dim a as variant
a = Range(???).value
Msgbox "Yada yada yada " & a & " yada yada"

Regards
Yngve

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

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