PDA

View Full Version : message box format



av8tordude
08-18-2010, 11:31 AM
I know how to create a message box, but i'm not sure how to input the following month within the message box. Can anyone assist? Thanks

Example: If the current month is August, i would like the following month (September) inserted within the message.


msgbox "Please download September database"

austenr
08-18-2010, 12:37 PM
MsgBox "Please download the ""September"" database"

austenr
08-18-2010, 12:38 PM
oops read it too fast. sorry dont have a clue :(

Bob Phillips
08-18-2010, 01:38 PM
MsgBox "Please download " & Format(DateSerial(Year(Date), Month(Date) + 1, 1), "mmmm") & " database"