+ Reply to Thread
Results 1 to 9 of 9

How to get a message popup if a date in specific cells are before today when opening sheet

  1. #1
    Registered User
    Join Date
    10-15-2017
    Location
    Wolverhampton
    MS-Off Ver
    2007+
    Posts
    12

    How to get a message popup if a date in specific cells are before today when opening sheet

    I have a excel sheet with names in cells a5 onwards and dates in cells d5 onwards with todays date in A3. I want a popup message when opening sheet if to give me the name and date if below todays date. I have the following code in the first sheet but nothing is happening.
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by JBeaucaire; 12-05-2017 at 06:53 PM.

  2. #2
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: How to get a message popup if a date in specific cells are before today when opening s

    You have the code in a worksheet module, it needs to be in the ThisWorkbook module.
    anthonyexcel-how-to-get-a-message-popup-if-a-date-in-specific-cells-are-before-today-when-openi.xlsm
    1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
    You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.

    Tom

  3. #3
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: How to get a message popup if a date in specific cells are before today when opening s

    Better yet, this one will run when any of the sheets are activated, it also goes into the ThisWorkbook module
    Please Login or Register  to view this content.
    anthonyexcel-how-to-get-a-message-popup-if-a-date-in-specific-cells-are-before-today-when-openi.xlsm

  4. #4
    Registered User
    Join Date
    10-15-2017
    Location
    Wolverhampton
    MS-Off Ver
    2007+
    Posts
    12

    Re: How to get a message popup if a date in specific cells are before today when opening s

    Still teaching myself excel - badly, googled this but can't find out how to save this in "thisworkbook module", any chance of enlightening me.

  5. #5
    Registered User
    Join Date
    10-15-2017
    Location
    Wolverhampton
    MS-Off Ver
    2007+
    Posts
    12

    Re: How to get a message popup if a date in specific cells are before today when opening s

    found it alt+f11

  6. #6
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: How to get a message popup if a date in specific cells are before today when opening s

    Sorry about that. Did it work as you wanted?

  7. #7
    Registered User
    Join Date
    10-15-2017
    Location
    Wolverhampton
    MS-Off Ver
    2007+
    Posts
    12

    Re: How to get a message popup if a date in specific cells are before today when opening s

    Yes thanks, its still a work in progress. I have lots of sheets with reminder dates and trying to pull it all together without having to open every sheet. Will probably end up trying to get reminders emailed when I have become more proficient - thanks for your help.

  8. #8
    Registered User
    Join Date
    10-15-2017
    Location
    Wolverhampton
    MS-Off Ver
    2007+
    Posts
    12

    Re: How to get a message popup if a date in specific cells are before today when opening s

    Hello gmr4evr1,still working on this. I want to always open with a specific sheet but want the popup to show, is it possible to specify the sheet name in the code?

  9. #9
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: How to get a message popup if a date in specific cells are before today when opening s

    It is possible - If it's sheet1 that you want to open with, this will work (paste into the ThisWorkbook module)
    Please Login or Register  to view this content.
    Change Sheet1 to the sheet you want to open with.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Pop up message based on date before opening spread sheet
    By rajasekar93 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-25-2015, 01:45 AM
  2. [SOLVED] Specific folder when opening windows popup folder selection with msoFileDialogFolderPicker
    By trizzo in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-18-2015, 11:05 AM
  3. popup alert message during the worksheet open and continuous work on the sheet popup jump
    By shailkam2001 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-04-2014, 10:24 AM
  4. Code to popup a message box after 15 days of the inserted date
    By hunmus in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-10-2012, 01:33 PM
  5. Popup message opening excel file !
    By janger in forum Excel General
    Replies: 1
    Last Post: 01-28-2012, 07:13 AM
  6. Replies: 6
    Last Post: 08-08-2011, 08:32 AM
  7. Cell Blink or message if cells date = today date
    By al007 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-29-2005, 09:40 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1