Results 1 to 4 of 4

msg box to display if date expired

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-08-2008
    Posts
    121

    msg box to display if date expired

    Hi,

    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 to display if the date is after that date like "Please review meeting date" , if that scheduled meeting has been missed.

    Is there a way of doing this using VBA?

    Please see attached sheet with more details.

    Any help would be much appreciated

    Many thanks
    Harry
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. search for max date and display other cell value
    By cdavenpo in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-21-2008, 05:25 PM
  2. looping issues
    By Marcus Gee in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-09-2007, 11:42 PM
  3. Specific Date Display
    By Hoopsah in forum Excel General
    Replies: 4
    Last Post: 08-10-2007, 07:37 AM
  4. display date in date format
    By nygwnj in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-24-2007, 11:32 PM
  5. Getting date to display after number input
    By Hemmiv in forum Excel General
    Replies: 15
    Last Post: 11-27-2006, 09:51 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