View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
James Ravenswood James Ravenswood is offline
external usenet poster
 
Posts: 143
Default 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