VB: Timer and Screen Pop-up

[saikong051]

Hi All,

I need help to improve this project i've created. right now this project is an Exam for our agents. You can try it first if you want. i've attached the file below.
i need a help in puting a timer that will compute the seconds or minutes it took the agent to finish the exam. timer should start after they click "Take the ETP" button. and finally, can someone also help me in creating a screen / a pop-up that will show the ff example.

[I]EXAMPLE:[/I]
Name of Examinee
Answer:
1. A = Correct
2. B = Incorrect
3. A = Correct
4. C = Correct
5. D = Incorrect

Thanks in advance.. Please feel free to post a comment below for any question or clarification about anything with regards to this project.

[nathansav]

Just use Timer, so have stTimer=timer and endTimer=timer then timeTaken=endTimer-stTimer.

Use a userform for the pop up.

[saikong051]

i'll try this one Nathansav. by the way, if i want to print the length of time it took them to finish the exam. i'll just use the same code that i've used in printing the result in the excel. right?

[nathansav]

Yes, that should be fine.

[TMS]

I've added a class module with Timer code in it. I've placed the start where I think it needs to go but feel free to move it around.

Please see your updated example.

Regards, TMS

[saikong051]

Thank you so much!!! it worked way better than the one im using. hehe. Thank you TMS!

i'll still wait for some input on the other problem before i tag this as solved.

[saikong051]

Thank you all for helping me on the timer for this project.
i was able to finish the remaining problem . by reading some of the posts when in using vbNewLine in MsgBox.

[TMS]

Good, well done. I quite fancied working on this, so you might as well have it:

Please Login or Register  to view this content.

See the attached updated example.

Regards, TMS

[saikong051]

Hi TMS,

Thank you very much. i'll try this file and code you've added.
This might be much better to what i've done. hehe
Thank you so much for the help!

[TMS]

You're welcome. Thanks for the rep.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

[saikong051]

Hi TMS,

i've already tagged this thread as SOLVED. but im trying to add Rep and im getting this message when i click Add Rep. "You must spread some Reputation around before giving it to TMS again."

but i was able to give Rep to you yesterday.

[TMS]

That's just to stop people "cheating". It forces you to give rep to other people before you can give rep to the same person again.

If you rep someone else for helping you, it'll be fine.

Regards, TMS