November 24, 2020
I am looking for a way to create a stopwatch that monitors the value of cell "N13" and runs until the value becomes "0". Then starts up again once the value of that cell becomes anything greater than "0". Basically, this cell is an indicator of how many items are currently being processed by a machine throughout the day. I would like to be able to monitor the actual amount of time that machine is processing items in a given day. I am unable to post it here unfortunately. I would like the stopwatch value to read into cell "U4". Is this possible or has it been done to where I can use the code with my modifications?
October 5, 2010
This post describes how to create a stopwatch and is controlled by the value in a cell. Modifying the code should do what you want.
Timer or Stopwatch in Excel VBA • My Online Training Hub
These posts may also be of help
Workbook & Worksheet Events in Excel VBA • My Online Training Hub
Charting Real Time Data in Excel • My Online Training Hub