Forum

Stopwatch based on ...
 
Notifications
Clear all

Stopwatch based on cell value

2 Posts
2 Users
0 Reactions
179 Views
(@scoti261)
Posts: 5
Active Member
Topic starter
 

Hello all,

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?

 
Posted : 02/08/2021 2:46 am
Philip Treacy
(@philipt)
Posts: 1629
Member Admin
 

Hi Scoti,

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

Regards

Phil

 
Posted : 05/08/2021 6:46 pm
Share: