Timer
 

Hi, I was trying to do something like.. if a value changes (S20) either by
macro/formula/user entry, timer should start and should show each second till
another entry is made in S20..

Timer
 

I think you would have to tie it to some event (Click, Change, Activate,
Deactivate, etc.) to trigger the timer, and to stop and reset the timer.
You would also neet to record the timer value at the stopping point and to
have a way of knowing who or what caused it to start, depending on what you
are trying to capture. Based on using S20, I would think the
Worksheet_Change event would work as a trigger. But what happens if the
user gets up and walks away from the workstation while the timer is running?



"Kashyap" wrote in message
...
Hi, I was trying to do something like.. if a value changes (S20) either by
macro/formula/user entry, timer should start and should show each second
till
another entry is made in S20..

Timer
 

Start point would e the stop point of another entry and it doesn't matter if
user gets up and walks away from the workstation while the timer is running..

I have already set sheet to take start and end time.. I now need a timer
which will run like a digital watch..