countdown timer

I have created an Excel test for our group at work, and my boss has asked me to put in a 30 minute countdown clock that will lock the spreadsheet down after 30 minutes (of if they finish early and press the Start/Stop button). I would like the timer to be started and stopped by a Start/Stop...

Hello, I am wondering if it is possible to add a countdown timer to a userform. Here is the design that I had in mind: a) Insert a textbox on the userform displaying the countdown b) Allow the user to interact with controls on userform while the countdown hasn't reached 0 c) Take action if...

How to do a Countdown timer in a Msgbox, then a message will appear after the timer. It's like 5..4..3..2..1.. Hello There! Thank you for your help !

Hi, I have some coding that navigates through a sheet and move data from a combobox to the sheet. However, I want to add a countdown timer on an existing userform and only allow users a given amount of time to add data. Here is the timer: Public Const nCount As Long = 60 Public nTime As...

Hi, I've made a workbook for my son to practice his times tables. It has 2 buttons: 'Start' unlocks the sheet, generates random numbers for the sums and does some formatting then relocks the sheet. 'Stop' unlocks the sheet, checks the answers and relocks the sheet. I would like to add a...

Hi people way smarter than me. I have a nice large workbook that I want to close at a certain time(for auto report calculations driven at my workstation) I have utilized the ontime command to open a message box to warn the user that i am going to close the workbook in 15 seconds. I though it...