+ Reply to Thread
Results 1 to 4 of 4

Popup 40 days after timestamp using vba code

  1. #1
    Registered User
    Join Date
    11-24-2007
    Posts
    17

    Popup 40 days after data entry(vba automatic script pref)

    Is it possible to have a form pop up after 40 days
    notifying the user that
    there data is old and should be revised?

    maybe like something like "IF Now()-Column("e")>40 days
    Then display once msg (please update the value(s)
    located in cell B1, C1, B9, D11, ect..)"

    column("E") being where my time stamp is set when someone posts data

    If it is possible could the pop up occur once on the
    excel file opening and list all the updates needed
    instead of a ton of individual pop ups for each
    old data entry?

    thanks a ton for any help yall can give.
    Last edited by xenador; 11-25-2007 at 02:39 AM.

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    It is possible to do what you want with VBA, but of course if your user does not enable macros then there will be no reminder! Why not simply use Conditional Formatting to highlight data that needs attention? See this

    http://www.excel-it.com/excel_condit...formatting.htm
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    11-24-2007
    Posts
    17
    thanks a ton, works great and extremely easy to setup.

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    Glad it helped, alays look for existing Excel functions before resorting to VBA.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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