+ Reply to Thread
Results 1 to 2 of 2

Reminders

Hybrid View

  1. #1
    Registered User
    Join Date
    10-10-2012
    Location
    south africa
    MS-Off Ver
    Excel 2003
    Posts
    2

    Question Reminders

    how can i set a time and date reminder in excel?

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2411
    Posts
    26,730

    Re: Reminders

    Welcome to the Forum!

    This is not supported by anything built into Excel. You would have to write VBA that would set a timer. There is a good tutorial on this here: http://www.ozgrid.com/Excel/run-macro-on-time.htm You would also have to develop some way for the user to enter the time that they would want the reminder to fire. The easiest thing would be to enter that data in a worksheet, but you would also have to have a button to set the time. Then decide what you want to happen. For example, you would create a simple user form that would pop up at the desired time.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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