+ Reply to Thread
Results 1 to 2 of 2

Stopwatch triggered by a changing value in a cell

  1. #1
    Registered User
    Join Date
    07-10-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2010
    Posts
    61

    Stopwatch triggered by a changing value in a cell

    Hi folks,

    I am trying to put together a macro that will run a stopwatch that is triggered by a cell value. I have come across many macros for the same that are triggered by button but i dnt have enough expertise to convert those codes to be triggered by a changin value in a cell. Could you folks please help me out with this?

    Many thanks,

    Naz

  2. #2
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Stopwatch triggered by a changing value in a cell

    If you have a macro like this:
    Please Login or Register  to view this content.
    to be triggered by a button, you can usually use something like:
    Please Login or Register  to view this content.
    to trigger the macro by a cell change, change A1 to the cell you want it to be triggered by and place the worksheet change macro in the worksheet object, not a standard module.

+ 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. Recording cell value changes from DDE triggered interface
    By tom412 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-06-2012, 06:09 PM
  2. Automatically entering a row in another tab, triggered by a specific value in a cell
    By Patrick L in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-15-2011, 02:50 PM
  3. Fixed Date in cell, triggered by input into a different cell
    By Denzil in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-04-2011, 05:58 AM
  4. DDE - which cell triggered a changed value?
    By jonmac in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-30-2010, 03:47 AM
  5. Can a macro be triggered when a cell is selected?
    By Linking to specific cells in pivot table in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-12-2005, 03:05 AM

Tags for this Thread

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