Incorpoarting cell contents into a message box
In article , Dave Peterson
writes
This may work, too:
MsgBox "Please go to " & Range("A1").text & " for further"
Hi Dave
OK thanks for that - it works perfectly first time also.
Best Wishes
On 06/01/2011 21:33, Rick Rothstein wrote:
As the content is a date , it is returning 01/01/2011
in the message box, when the cell itself is formatted
to read January 2011.
Is it possible to modify the code to return a
mmmm yyyy format in the message box?
You do realize if you don't tell us all of your conditions up front, there is
minimum chance that we would be able to guess them, right?
Give this code a line a try...
MsgBox "Please go to " & Format(Range("A1").Value, _
Range("A1").NumberFormat) & " for further"
Rick Rothstein (MVP - Excel)
|