PresidentEvil
New Member
- Joined
- Jan 2, 2021
- Messages
- 34
- Office Version
- 2021
- 2016
- Platform
- Windows
Hi All,
I've create my own MCQ Test sheet that can be used to give the test by collecting basic info of user followed by MCQ test. Once the user clicks finish button, result sheet is displayed and a copy of workbook is sent to a particular mail id on outlook.
I want a code that allows me to fetch the total time mentioned on a cell and start the timer as soon as user clicks start button. Once the user completes the test, he click Finish button. If user cannot complete the test within the time runs out, still the email should be sent with half answered work book.
To simply summarise, I type "15 " in A1 cell. So when I click start button, the time should start at 15 mins coming down to 0 mins. Then the finish button macro is run. Please assist.
I've create my own MCQ Test sheet that can be used to give the test by collecting basic info of user followed by MCQ test. Once the user clicks finish button, result sheet is displayed and a copy of workbook is sent to a particular mail id on outlook.
I want a code that allows me to fetch the total time mentioned on a cell and start the timer as soon as user clicks start button. Once the user completes the test, he click Finish button. If user cannot complete the test within the time runs out, still the email should be sent with half answered work book.
To simply summarise, I type "15 " in A1 cell. So when I click start button, the time should start at 15 mins coming down to 0 mins. Then the finish button macro is run. Please assist.
