ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   msg box help (https://www.excelbanter.com/excel-worksheet-functions/121033-msg-box-help.html)

Anthony

msg box help
 
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


All times are GMT +1. The time now is 10:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com