+ Reply to Thread
Results 1 to 5 of 5

Auto Update data in a cell if it contains date less than today after 18:00 hrs using VBA.

  1. #1
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    2,192

    Auto Update data in a cell if it contains date less than today after 18:00 hrs using VBA.

    Auto Update data in a cell if it contains date less than today after 18:00 hrs using VBA.

    Dear Forum,

    I have a file where I store two dates for Insurance certification details of all employees in my organisation.
    These certificates expire in three years, I have dates from past so many years which are nearing expiry, the moment the dates expire I change the date content to "Due for Renewal" for all employees who are still Active in the system , the Active Flag being stored in another column.

    So, I was wondering if this could be done automatically on the Sheet Open event..for all the dates which are less than today after 18:00 hrs as the certificate is valid till 17th May i.e today then this should only impact or show as "Due for Renewal" after 18:00 HRS...

    So, is this possible ?

    Please can someone help me with the VBA code if the Issuance Date is in the column D and the Till Date is in the column E and the Active Flag is in the column F..

    Warm Regards
    e4excel

  2. #2
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    2,192

    Re: Auto Update data in a cell if it contains date less than today after 18:00 hrs using V

    Any suggestions in getting this done....

  3. #3
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    2,192

    Bump No Response

    Bump No Response

  4. #4
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    2,192

    Bump No Response

    Bump No Response

  5. #5
    Registered User
    Join Date
    01-17-2013
    Location
    Austin, TX
    MS-Off Ver
    Excel 2007
    Posts
    84

    Re: Bump No Response

    If you still have this problem, I could help. I just solved a similar issue for my own company. I'll need your spread sheet and I could send you an example. You can change the data but otherwise it should be 'close ' to the real thing.

+ 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. [SOLVED] Auto Fill Cell With Today's Date And Shift Cells To The Right
    By EricBarnes88 in forum Excel General
    Replies: 9
    Last Post: 02-06-2014, 09:26 AM
  2. [SOLVED] Getting Today's Year to Update a Date in a Cell
    By karimel_romeo in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-07-2013, 03:33 PM
  3. Replies: 3
    Last Post: 07-01-2013, 01:58 PM
  4. Click on a blank cell to auto add today's date
    By DK1981 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 11-10-2011, 05:55 AM
  5. Replies: 1
    Last Post: 06-09-2010, 01:05 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