Consulting

Results 1 to 4 of 4

Thread: message box format

  1. #1

    message box format

    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"

  2. #2
    Moderator VBAX Master austenr's Avatar
    Joined
    Sep 2004
    Location
    Maine
    Posts
    2,033
    Location
    [VBA]MsgBox "Please download the ""September"" database"[/VBA]
    Peace of mind is found in some of the strangest places.

  3. #3
    Moderator VBAX Master austenr's Avatar
    Joined
    Sep 2004
    Location
    Maine
    Posts
    2,033
    Location
    oops read it too fast. sorry dont have a clue
    Peace of mind is found in some of the strangest places.

  4. #4
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    [vba]

    MsgBox "Please download " & Format(DateSerial(Year(Date), Month(Date) + 1, 1), "mmmm") & " database"
    [/vba]
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •