+ Reply to Thread
Results 1 to 2 of 2

start stop timer

  1. #1
    Forum Contributor
    Join Date
    06-24-2013
    Location
    philippines
    MS-Off Ver
    Excel 2007
    Posts
    199

    start stop timer

    Hello All

    I came across attached macro in the net and was wondering if somebody can modify it as follows.

    1. Add and additional 20 rows, start and top button included.
    2. When the start button is clicked, it would turn green. and when the stop is clicked, start button would go back to gray.
    3. an additional "SAVE" button (beside the add and remove buttons) where the purpose is to transfer all (column A to L) in a database. note that it should start pasting the data on the last available row.

    hope someone can assist on me pleaseee..
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    08-07-2014
    Location
    Quito, Ecuador
    MS-Off Ver
    Excel 2016 & 365, Windows 10
    Posts
    511

    Re: start stop timer

    Hi @ melody10

    I've modified a bit your original code to match what you asked for.

    When you start with a table, you can add as many rows as you need, then the "add buttons" will include a couple of buttons on each filled line.
    The "remove" will clean all buttons and all data in "Time worked"
    The "Save" button will copy all the data to the bottom of the Base .
    Attached Files Attached Files
    Barriers are there for those who don't want to dream

+ 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] Macro for Timer Start/Stop on Workbook Activate/ Deactivate
    By bgreeson in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-29-2016, 10:59 AM
  3. VBA MACRO issues for start/stop timer on job sheet.
    By voidcreativ in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-18-2015, 05:54 AM
  4. Start/Stop timer
    By JonathanB2 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-10-2014, 07:00 AM
  5. Start/Stop button help Timer auto update
    By Tortus in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-30-2014, 11:16 AM
  6. Replies: 1
    Last Post: 12-12-2012, 08:46 PM
  7. How do I use VBA timer subroutines to start and stop random number generator?
    By penn919 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-06-2008, 09:07 PM

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