Hi All

I'm trying to incorporate the contents of cell A1 into a message box but
am struggling for syntax. The content of A1 is text resultant of a
formula.

The box has some leading and trailing text ;

MsgBox "Please go to " (contents of A1) " for further information."


Grateful for any advice

On Jun 1, 8:10*pm, Colin Hayes wrote:
Hi All

I'm trying to incorporate the contents of cell A1 into a message box but
am struggling for syntax. *The content of A1 is text resultant of a
formula.

The box has some leading and trailing text ;

MsgBox "Please go to " *(contents of A1) *" for further information."

Grateful for any advice

Sub marine()
MsgBox "Please go to " & Range("A1").Value & " for further
information."
End Sub

In article
,
James Ravenswood writes
On Jun 1, 8:10*pm, Colin Hayes wrote:
Hi All

I'm trying to incorporate the contents of cell A1 into a message box but
am struggling for syntax. *The content of A1 is text resultant of a
formula.

The box has some leading and trailing text ;

MsgBox "Please go to " *(contents of A1) *" for further information."

Grateful for any advice

Sub marine()
MsgBox "Please go to " & Range("A1").Value & " for further
information."
End Sub

Hi

OK thanks for that.

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?

Thanks again.

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)

In article , Rick Rothstein
writes
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)



Hi

OK thanks for your help. It works fine now.

I'm grateful for your time and expertise.

This may work, too:

MsgBox "Please go to " & Range("A1").text & " for further"

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)

--
Dave Peterson

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)