slang
01-04-2013, 06:47 AM
Hello Excel gods:bow:
I have a survey the user inputs data into which we would like to know how long the user took to complete it.
The survey is on a hidden sheet and invoked through code and can only be exited by completing the required fields and choosing a complete button.
So my logic is that if the user actually completed the survey correctly it would take longer than just answering yes to everything just to get it out of the way.:devil2:
So I was thinking about code in the worksheetactivate event that would set the start time,
Static StrtTime As Date
Static Counter As Date
StrtTime = Now
and another in the complete button code,
Counter = Now - StrtTime
that determined the elapsed time spent on the sheet.:dunno
First time with static variables:)
There is probably a better way....
Thanks all.
I have a survey the user inputs data into which we would like to know how long the user took to complete it.
The survey is on a hidden sheet and invoked through code and can only be exited by completing the required fields and choosing a complete button.
So my logic is that if the user actually completed the survey correctly it would take longer than just answering yes to everything just to get it out of the way.:devil2:
So I was thinking about code in the worksheetactivate event that would set the start time,
Static StrtTime As Date
Static Counter As Date
StrtTime = Now
and another in the complete button code,
Counter = Now - StrtTime
that determined the elapsed time spent on the sheet.:dunno
First time with static variables:)
There is probably a better way....
Thanks all.