Incorpoarting cell contents into a message box
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
|