Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Page 1 of 2 1 2 LastLast
Results 1 to 10 of 17

Thread: message box to warn of due date

  1. #1
    Join Date
    10th June 2005
    Posts
    80

    message box to warn of due date

    ok so i need some help before i go crazy.
    i did read the other thread about the popup message box but i still cannot get mine to work using hers as an example

    i have a workbook that needs to popup a message box warning "Trespass Letter is Expiring" one month before the due date for the letter.
    i need the macro to check the column F for the 'End Date' and minus a month so that one month before the due date you get a warning message.
    is this possible?
    I've tried so many time to do this myself but im no expert in VB.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    14th July 2004
    Posts
    10,541

    Re: message box to warn of due date

    When do you want this to occur?

    Where is the date located?

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    10th June 2005
    Posts
    80

    Re: message box to warn of due date

    everytime i open the workbook...and the workbook is shared.
    what date? the 'End Date'? is in column F

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    14th July 2004
    Posts
    10,541

    Re: message box to warn of due date

    Which cell in column F or are there more than one entries?

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    10th June 2005
    Posts
    80

    Re: message box to warn of due date

    ya there are a whole year of entries..so the entire column f i guess.

    Excel Video Tutorials / Excel Dashboards Reports


  6. #6
    Join Date
    14th July 2004
    Posts
    10,541

    Re: message box to warn of due date

    Could you please give some more information?

    What do you want appear in the msgbox?

    Do you want to check every row?

    Perhaps you could attach a small sample workbook.

    Excel Video Tutorials / Excel Dashboards Reports


  7. #7
    Join Date
    25th January 2003
    Location
    UK
    Posts
    2,745

    Re: message box to warn of due date

    Hi Newt,

    While a VBA routine is certainly one option (especially if you specifically want the message box warning) have you considered simply using Conditional Formatting to flag the 'late' dates, for example by colouring the cell red?

    If you want to try this select the data conerned and then choose ConditionalFormatting from the Format menu. Select 'Cell value is', 'less than', and then '=TODAY()-30' in the final box. Click on the Format button to select the appropriate indicator, eg Red background, then OK to apply.

    Just a thought
    Cross-poster? Read this: Cross-posters
    Struggling to use tags (including Code tags)? : Forum tags

  8. #8
    Join Date
    12th March 2004
    Posts
    561

    Re: message box to warn of due date

    Quote Originally Posted by Richie(UK)
    Hi Newt,

    While a VBA routine is certainly one option (especially if you specifically want the message box warning) have you considered simply using Conditional Formatting to flag the 'late' dates, for example by colouring the cell red?

    If you want to try this select the data conerned and then choose ConditionalFormatting from the Format menu. Select 'Cell value is', 'less than', and then '=TODAY()-30' in the final box. Click on the Format button to select the appropriate indicator, eg Red background, then OK to apply.

    Just a thought

    Just a thought... combine the message box warning and the conditional formating.

    Use the conditional format to identify the rows needing letters sent. Use the message box when the workbook is opened to notify the user that anything from Column F that is read needs a letter.

    [code]

    See attached
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  9. #9
    Join Date
    10th June 2005
    Posts
    80

    Re: message box to warn of due date

    here is an example of my workbook
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  10. #10
    Join Date
    12th March 2004
    Posts
    561

    Re: message box to warn of due date

    How is this
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Warn User To Save Before Importing Data
    By Paul Patient in forum EXCEL HELP
    Replies: 5
    Last Post: June 26th, 2008, 19:40
  2. Warn Of Duplicates Records Added From UserForm
    By Mentor in forum EXCEL HELP
    Replies: 6
    Last Post: March 14th, 2008, 12:27
  3. Warn User When Replacing Cell Content
    By ibble in forum EXCEL HELP
    Replies: 2
    Last Post: February 16th, 2008, 03:42
  4. Code To Warn When Vba Editor Is Opened
    By HarryFrohlich in forum EXCEL HELP
    Replies: 2
    Last Post: July 3rd, 2007, 19:54
  5. VBA to disable Delete or warn to clear only?
    By kimberly in forum EXCEL HELP
    Replies: 5
    Last Post: September 5th, 2004, 11:34

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
  •  
porno