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
|