Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Timer | Excel Programming | |||
VBA Timer | Excel Programming | |||
Stopping a Timer / Running a timer simultaneously on Excel | Excel Discussion (Misc queries) | |||
timer | Excel Programming | |||
Timer | Excel Programming |