+ Reply to Thread
Results 1 to 9 of 9

Countdown timer Code not working

  1. #1
    Registered User
    Join Date
    02-22-2010
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    12

    Countdown timer Code not working

    Hello Everyone...

    Can anyone help me on my issue. Please check the VB code, i don't know what is wrong.

    Moses
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    08-23-2009
    Location
    Hampshire, UK
    MS-Off Ver
    Excel 2003, Excel 2007
    Posts
    328

    Re: Countdown timer Code not working

    Hi Moses

    You need to put some of the code in a normal module, as indicated by a remark in the code. I've done it in the attached file which counts down correctly.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    02-22-2010
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: Countdown timer Code not working

    Thank you very much for your reply...

    sir, but i looking for something else, like if you check my work book, you can understand.

    Please help me if you can

    Thank you for your time and help

    Moses
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor
    Join Date
    08-23-2009
    Location
    Hampshire, UK
    MS-Off Ver
    Excel 2003, Excel 2007
    Posts
    328

    Re: Countdown timer Code not working

    when I entered date and time in A7, I want to start countdown time B7 Automatically. Is it possible.
    The code in your file is for a timer which counts down the number of seconds entered in cell A1 after pressing the button.

    Are you asking for a timer which won't start counting down until the current date and time equal the value that you are going to enter in A7 and counts down the amount of time entered in B7?

  5. #5
    Registered User
    Join Date
    02-22-2010
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: Countdown timer Code not working

    Yes its working. what we need to do if we want to change the format like 00:00:00 (hh:mm:ss) 01:59:59.

    Do you any idea...

    Thank you for your Help my friend

    Moses

  6. #6
    Valued Forum Contributor
    Join Date
    08-23-2009
    Location
    Hampshire, UK
    MS-Off Ver
    Excel 2003, Excel 2007
    Posts
    328

    Re: Countdown timer Code not working

    If you want to enter the time in A1 as hh:mm:ss you need to change a line in the module code from
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    02-22-2010
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: Countdown timer Code not working

    Perfect its working...

    What to do if wants the same format in A1 to A20

    Thank you very much my friend..

    ...Moses

  8. #8
    Valued Forum Contributor
    Join Date
    08-23-2009
    Location
    Hampshire, UK
    MS-Off Ver
    Excel 2003, Excel 2007
    Posts
    328

    Re: Countdown timer Code not working

    Do you mean that you want to have 20 different countdowns running at the same time? I don't know if that's possible - I certainly couldn't write the code for it. Perhaps someone else can help?

  9. #9
    Registered User
    Join Date
    02-22-2010
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: Countdown timer Code not working

    Hello Friend...

    Are there any possibility...

    Moses

+ 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