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)