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"
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"
Hi renegan
Dim a as variant
a = Range(???).value
Msgbox "Yada yada yada " & a & " yada yada"
Regards
Yngve
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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
Thank you both John and evgny. It worked fine.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks