Help on Questionnaire in Excel using VBA

[VARGEESH]

Hello!

Please advise me on the below scenario.

Plan:
I would like to prepare a questionnaire in Excel using VBA, One question for one sheet, probably 20 sheets will be there.
When the user start the test, a timer will be running on "A1", if the time value > 60(1 Minute) then it will go to the next question(Next sheet) automatically.

Sample Timer code:

Sub StartTimer()

Dim Seconds As Integer
For Seconds = 1 To 10   
    Application.Wait (Now + TimeValue("0:00:01")) ' Wait for a second
    Range("A1").Value = Seconds
Next Seconds
MsgBox "Ten Seconds Elapsed"

End Sub

Problem: When the timer is running, the user is not able to use the excel.

Could you please advise me how can I make the questionnaire with Timer in Excel?

Thank you!
Vargeesh

 

[PCosta87]

Hi @VARGEESH

You can try something like this:
http://stackoverflow.com/questions/...-in-excel-that-continues-when-inputs-are-made

Although it works ok for a multiple selection kind of test, where user does not change cell contents manually, it will not work very well for something that requires user to input formulas or values into cells as the counter will stop and wait

 

[Chihiro]

Excel isn't ideal for this type of need. Normally, I'd leverage google form.

Create custom web site with java script timer. Embed google form and collect result in google sheet and/or send email notification.

Otherwise, just track time stamp and deduct points if question isn't completed within allotted time.