A nice easy one hopefully?
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: A nice easy one hopefully?

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    Northampton, UK
    Posts
    33
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Ok, with my System I would like the same pop up reminder message to appear on the last day of every month. Any ideas? Thanks, BEX

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Perth Australia
    Posts
    1,579
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Hi Beckwa

    You could try this:

    Right click a sheet tab, left click View Code.
    In the VBA Project window at left select This Workbook.
    Paste this code in the large white area

    Private Sub Workbook_Open()
    If Day(Date + 1) = 1 Then MsgBox "Last Day of Month"
    End Sub

    Above the code are 2 drop down boxes, in the left one select Workbook and in the right one select Open. Use Alt+F11 to return to sheet.

    This message should display when you open the workbook on the last day of the month

    regards
    Derek

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com