Timer in Excel
33.5 هزار بار بازدید -
10 سال پیش
-
Our Excel training videos on
Our Excel training videos on YouTube cover formulas, functions and VBA. Useful for beginners as well as advanced learners. New upload every Thursday.
For details you can visit our website:
http://www.exceltrainingvideos.com/ti...
One of our YouTube subscribers wants to know how to create a timer in Excel using VBA for an examination. The timer has the following properties:
1. It starts when the workbook is opened
2. The user inputs his roll number or ID
3. The roll number or ID is captured into cell C1 of the Excel worksheet after confirmation
4. The user takes his exam
5. At the scheduled end time the timer stops, the Excel file is saved as a read-only and standard XLSX file using data from the worksheet and the computer system and finally the workbook closes automatically.
For details you can visit our website:
http://www.exceltrainingvideos.com/ti...
One of our YouTube subscribers wants to know how to create a timer in Excel using VBA for an examination. The timer has the following properties:
1. It starts when the workbook is opened
2. The user inputs his roll number or ID
3. The roll number or ID is captured into cell C1 of the Excel worksheet after confirmation
4. The user takes his exam
5. At the scheduled end time the timer stops, the Excel file is saved as a read-only and standard XLSX file using data from the worksheet and the computer system and finally the workbook closes automatically.
10 سال پیش
در تاریخ 1393/02/19 منتشر شده
است.
33,557
بـار بازدید شده