| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Threaded Mode
