flag up message if a date is missed
I have a tracking system in excel where I've got a planned and an actual date for each stage in a project so each stage has to be done in order.
At several points in the project, meetings are set up accordingly: in the Second Tuesday of every 4 week period. So at the start of the project a provisional date is set up for each meeting.
I want a message box or something like it to display "Please review meeting date" , if that scheduled meeting has been missed.
Is there a way of doing this?
Any help would be much appreciated
Valued Forum Contributor
Have you tried using Data Validation option.
great idea! didn't think of that
Data validation kind of works but I want the message to display all the time and not just when I click on the cell?
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By DaKohlmeyer in forum Excel Programming / VBA / Macros
Last Post: 07-28-2008, 04:49 PM
By josi_kc in forum Excel General
Last Post: 12-15-2007, 09:15 AM
By Rams in forum Excel Programming / VBA / Macros
Last Post: 12-10-2007, 10:02 AM
By Marcus Gee in forum Excel Programming / VBA / Macros
Last Post: 10-09-2007, 11:42 PM
By SPenney in forum Excel Programming / VBA / Macros
Last Post: 07-24-2007, 10:03 AM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1