ExcelBanter - msg box help

thanks JIM, WORKS JUST FINE

"Jim Thomlinson" wrote:

MsgBox "Receipt for " & vbCrLf & _
format(Sheets("Sheet1").Range("A1").Value, "mm/dd/yyyy") & vbCrLf & _
" has been created and is ready to print!" , _
vbOKOnly & vbExclamation, " Receipt Daily Info"
--
HTH...

Jim Thomlinson

"Anthony" wrote:

Hi,

is it possible to add a date which is taken from a cell ref within a
worksheet and place it into my msg box??

the date is in sheet1 cell A1
and here is my current msg box

MsgBox ("Receipt for " & vbCrLf & _
"has been created and is ready to print! "), vbOKOnly & vbExclamation, _
(" Receipt Daily info")

I want the date to be added after the text "Receipt for" in the msg box

thanks in advance