+ Reply to Thread
Results 1 to 5 of 5

msg box for when an action is due

  1. #1
    Registered User
    Join Date
    06-17-2015
    Location
    manila, ph
    MS-Off Ver
    ms 2010
    Posts
    2

    Exclamation msg box for when an action is due

    Hi all,

    I very new to macro and hardly know the vba coding. I am currently working on a tracker where I have 4 important tasks that needs to be completed. With this 4 tasks I would want an alert message box appearing 3 days before the action is due. I have checked the forums with similar problems as I have but I am on the weeds and do not know how to proceed. I hope you can help.

    Attached is the workbook.

    thanks.
    Jam

    pop up msg.xlsmpop up msg.xlsm

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: msg box for when an action is due

    Hi,

    The first thing to decide is what event should cause the msgbox to pop up?
    That could be immediately you open the workbook, activating/selecting a particular sheet, pressing a button or a few other events.

    Then I'd suggest you have a helper column or columns that contain a formula the identifies whether your tracker date is 3 days or less in the future.

    e.g. =IF(A1-TODAY()<=3,"alert","")
    where A1 is the tracker date

    You could conditionally format this helper column and paint the cell red if any cells return "alert". You may feel this is sufficient and avoids the need for VBA.
    If you want VBA then with whatever event you choose you would test for any cell that has "alert" and if there are any you would invoke the MSGBOX.

    Hope this helps
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    06-17-2015
    Location
    manila, ph
    MS-Off Ver
    ms 2010
    Posts
    2

    Re: msg box for when an action is due

    thanks richard.

    to answer your questions, when the workbook is open or while its open.

    i would prefer VBA, since my audience would likely act on the deadline when its alert/error message.

    Capture.PNG

    the highlighted items above, is when the msgbox would be in use 3 days before that date.

    i hope i was able to bring more clarity.

  4. #4
    Valued Forum Contributor Kamboj's Avatar
    Join Date
    09-25-2014
    Location
    India
    MS-Off Ver
    2003 - 2010
    Posts
    430

    Re: msg box for when an action is due

    Here is your file.
    Attached Files Attached Files

  5. #5
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: msg box for when an action is due

    Quote Originally Posted by jamailexcel View Post
    thanks richard.

    to answer your questions, when the workbook is open or while its open.

    i would prefer VBA, since my audience would likely act on the deadline when its alert/error message.

    Attachment 401597

    the highlighted items above, is when the msgbox would be in use 3 days before that date.

    i hope i was able to bring more clarity.
    Hi,

    Kamboj has given you a solution based on the initial requirement, but I'm puzzled by your comments here. WHy have you singled out the highlighted items. ARe you saying they are the only ones that should be considered for the messagebox when they are within 3 days, and if so what's the criteria for choosing only these.

    In any case there appears to be two shades of highlighting. My original thought was that only those with the word 'completed' in the 2nd column should be considered but I can't see any common feature with the lightly shaded items.

+ 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. My Action Tracker Keeps placing my competed action rows on sheet2 in the same place.
    By billybong33 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-18-2014, 04:01 PM
  2. On Action?
    By John in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-21-2006, 02:10 PM
  3. [SOLVED] If column A completely empty, one action; if not, another action?
    By StargateFanFromWork in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-15-2006, 04:15 PM
  4. RE: On Action
    By Greg Wilson in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-26-2006, 07:00 PM
  5. OLE action?
    By choice in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-27-2005, 03:06 PM

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