how to make reminder in excel .

Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: how to make reminder in excel .

  1. #1
    New Member
    Join Date
    Jan 2011
    Location
    dubai,united arab emirates
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    INDIA
    Posts
    3,875
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: how to make reminder in excel .

    use application ontime method for this.
    Regards,
    Pedie
    MS OFFICE 2016/EXCEL 2016: Window7: 64BIT
    Visit YouTube.com/VBAa2z


  3. #3
    Board Regular tweedle's Avatar
    Join Date
    Aug 2010
    Location
    35.883348,-78.510216
    Posts
    1,559
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    INDIA
    Posts
    3,875
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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 10:55 PM.
    Regards,
    Pedie
    MS OFFICE 2016/EXCEL 2016: Window7: 64BIT
    Visit YouTube.com/VBAa2z


  7. #7
    New Member
    Join Date
    Jan 2011
    Location
    dubai,united arab emirates
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: how to make reminder in excel .


  8. #8
    Board Regular pedie's Avatar
    Join Date
    Apr 2010
    Location
    INDIA
    Posts
    3,875
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: how to make reminder in excel .

    sure lemmi check
    Regards,
    Pedie
    MS OFFICE 2016/EXCEL 2016: Window7: 64BIT
    Visit YouTube.com/VBAa2z


  9. #9
    Board Regular pedie's Avatar
    Join Date
    Apr 2010
    Location
    INDIA
    Posts
    3,875
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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 2016/EXCEL 2016: Window7: 64BIT
    Visit YouTube.com/VBAa2z


  10. #10
    New Member
    Join Date
    Jan 2011
    Location
    dubai,united arab emirates
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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

User Tag List

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