Results 1 to 4 of 4

Popup 40 days after timestamp using vba code

Threaded View

  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.

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