+ Reply to Thread
Results 1 to 6 of 6

Cells as Buttons that will start a Countdown

  1. #1
    Registered User
    Join Date
    06-19-2017
    Location
    California
    MS-Off Ver
    2016
    Posts
    5

    Cells as Buttons that will start a Countdown

    I have seen ways to make cells as buttons to put checkmarks. What I want though is to make cells clickable. Then after it is clicked it will start a countdown.
    To be more exact.

    1. Click cell
    2. Once cell is clicked it will have the number 10
    3. Everyday it will count down to 9 until 0
    4. Once it reaches 0 the cell will be blank again. (This one isn't a big deal if the 0 is still left in there)

    Is this possible to do?

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Cells as Buttons that will start a Countdown

    Try this in the sheet module:

    Please Login or Register  to view this content.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Registered User
    Join Date
    06-19-2017
    Location
    California
    MS-Off Ver
    2016
    Posts
    5

    Re: Cells as Buttons that will start a Countdown

    Awesome it worked!
    But, is there a way to make it so that the countdown is not initiated by a another click but instead by date or days.
    What I was thinking was the logic is once its clicked it has a date associated with it. It can then reference the current date and lets say the difference is 3 then the number will be 7. if its 10 then its 0.
    If this is too complicated then thank you for your help! I can probably work off of what you gave me.

  4. #4
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Cells as Buttons that will start a Countdown

    Thanks for the rep!

    Do you mean this?

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    06-19-2017
    Location
    California
    MS-Off Ver
    2016
    Posts
    5

    Re: Cells as Buttons that will start a Countdown

    This is like 95% of what I need so again thank you!
    Is there a way to make ADat = the date of change tho (or date of click or selection)
    I will mark this as solved though because if the above can't be done I can work with what I have.

  6. #6
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Cells as Buttons that will start a Countdown

    Not sure what you mean - ADat is compared to the Current Date. You could put ADat anywhere - it doesn't need to be in the code

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Displaying a unique countdown timer with Start/Stop/Reset buttons on multiple lines
    By drememagik in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-07-2017, 07:51 PM
  2. [SOLVED] Can I Start a Countdown Timer after URL is Clicked
    By Bkewlbro in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-14-2016, 03:32 PM
  3. [SOLVED] Get a countdown timer to start automatically when spreadsheet opens
    By zamirkaya in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-15-2016, 11:29 AM
  4. Countdown with an action to start the next timer
    By hemmjonny in forum Excel General
    Replies: 2
    Last Post: 04-09-2016, 08:08 AM
  5. Six 30 minute fixed countdown timers with start, stop and reset buttons.
    By Marty62 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-18-2014, 07:31 AM
  6. Replies: 2
    Last Post: 12-18-2014, 02:33 AM
  7. [SOLVED] Macro needed to increase a cell value and start countdown timer
    By Klayton in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 04-08-2013, 08:34 AM

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