Page 1 of 2 12 LastLast
Results 1 to 10 of 13

how to make reminder in excel .

This is a discussion on how to make reminder in excel . within the Excel Questions forums, part of the Question Forums category; I have excel file Use it as a reminder of the daily work ... What a way to make a ...

  1. #1
    New Member
    Join Date
    Jan 2011
    Location
    dubai,united arab emirates
    Posts
    19

    Default how to make reminder in excel .

    I have excel file Use it as a reminder of the daily work ...

    What a way to make a timer in Excel
    If time is in the computer match with the time in the cell change color.

    Example:

    Computer time 5:15
    I have work at 06:00 and I've written this time in a cell, Excel
    If computer clock match with working time Automatically change the color of the cell

  2. #2
    Board Regular pedie's Avatar
    Join Date
    Apr 2010
    Location
    NZ@In
    Posts
    3,779

    Default Re: how to make reminder in excel .

    use application ontime method for this.
    Regards,
    Pedie
    MS OFFICE 2013: Window7: 64BIT

  3. #3
    Board Regular tweedle's Avatar
    Join Date
    Aug 2010
    Location
    35.883348,-78.510216
    Posts
    1,553

    Default Re: how to make reminder in excel .

    You can do this with conditional formatting on the cell containing the time.
    Such that if K5 is the cell with the time, a conditional format formula would look like:
    Code:
    =TIME(HOUR(NOW()),MINUTE(NOW()),SECOND(NOW()))>=K5
    This would reset every day however.
    You would need to utilize a full date/time to make it persistent, which goes to a different formula.
    Win7::MSO2007
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    I have no special talent.
    I am only passionately curious. - Albert Einstein
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    "Simple" and "Easy" are a matter of perspective
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    Solutions here may be 'representative' and you may
    need to actually put some thought to your own needs.

  4. #4
    New Member
    Join Date
    Jan 2011
    Location
    dubai,united arab emirates
    Posts
    19

    Default Re: how to make reminder in excel .

    Quote Originally Posted by pedie View Post
    use application ontime method for this.


    how i use this application ??

    thank you

  5. #5
    New Member
    Join Date
    Jan 2011
    Location
    dubai,united arab emirates
    Posts
    19

    Default Re: how to make reminder in excel .

    Quote Originally Posted by tweedle View Post
    You can do this with conditional formatting on the cell containing the time.
    Such that if K5 is the cell with the time, a conditional format formula would look like:
    Code:
    =TIME(HOUR(NOW()),MINUTE(NOW()),SECOND(NOW()))>=K5
    This would reset every day however.
    You would need to utilize a full date/time to make it persistent, which goes to a different formula.

    i do that & cell give me 0

  6. #6
    Board Regular pedie's Avatar
    Join Date
    Apr 2010
    Location
    NZ@In
    Posts
    3,779

    Default Re: how to make reminder in excel .

    roughly and quick way...

    running time. Enter both the code in standard module and run timer..
    Dim NextTick As Date
    Sub timer()
    Range("A1").Value = CDbl(Time)
    NextTick = Now + TimeValue("00:00:01")
    Application.OnTime NextTick, "timer"
    alertme
    End Sub

    then for example you can enter time in range "b2" when you want the pop up...

    another try..
    sub alertme
    if range("B1").value < range("A1").value then
    msgbox "Alert...times up"
    On Error Resume Next
    Application.OnTime NextTick, "timer", , False

    end if
    end sub
    Last edited by pedie; Jan 21st, 2011 at 09:55 PM.
    Regards,
    Pedie
    MS OFFICE 2013: Window7: 64BIT

  7. #7
    New Member
    Join Date
    Jan 2011
    Location
    dubai,united arab emirates
    Posts
    19

    Default Re: how to make reminder in excel .


  8. #8
    Board Regular pedie's Avatar
    Join Date
    Apr 2010
    Location
    NZ@In
    Posts
    3,779

    Default Re: how to make reminder in excel .

    sure lemmi check
    Regards,
    Pedie
    MS OFFICE 2013: Window7: 64BIT

  9. #9
    Board Regular pedie's Avatar
    Join Date
    Apr 2010
    Location
    NZ@In
    Posts
    3,779

    Default Re: how to make reminder in excel .

    As i check your sheet it does not give much explaination...
    Not sure what to do..
    Regards,
    Pedie
    MS OFFICE 2013: Window7: 64BIT

  10. #10
    New Member
    Join Date
    Jan 2011
    Location
    dubai,united arab emirates
    Posts
    19

    Default Re: how to make reminder in excel .

    Quote Originally Posted by pedie View Post
    As i check your sheet it does not give much explaination...
    Not sure what to do..


    In this file there are some times
    I want to alert in the cell at equal times with the computer clock

Page 1 of 2 12 LastLast

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com