LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default create messagebox when a date is overdue

When I open a workbook in Excel, I want to have a messagebox pop up if there
are due dates not completed. For example: Cell A1 has a Due Date. Cell B1 has
a Date Completed. If on the due date, or a specified number of days prior to
the due date, the Date Completed is not populated, I want a messagebox saying
"Task is due on [date] and is not completed."

Any help would be appreciated.

Cebubum
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I highlight a cell when a date is overdue? Bel Excel Discussion (Misc queries) 1 March 18th 09 03:06 AM
Calculating overdue date fields AHizon via OfficeKB.com Excel Worksheet Functions 3 December 8th 08 07:24 PM
Trying to create an overdue message based on set dates Craig Excel Discussion (Misc queries) 5 November 23rd 07 04:05 PM
need an overdue date to highlight Sarge Excel Discussion (Misc queries) 1 February 3rd 05 07:33 PM
Date Overdue function, Macro, or VBS Galsaba Excel Discussion (Misc queries) 5 January 14th 05 12:26 AM


All times are GMT +1. The time now is 09:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"