RobbieC
Active Member
- Joined
- Dec 14, 2016
- Messages
- 376
- Office Version
- 2010
- Platform
- Windows
Hi there, I have a userform with a few buttons on it for user selection and button1 is the main enter/unload button
What I would like to do is have a small 10 second countdown (starts when loaded) whereas if nothing is clicked, button1_click is called
But if any of the other buttons are clicked, the countdown stops (I can assign this code to each button)
I was trying a bit of code which invloved refreshing the userform to update the countdownTime.caption, but this would not let me click anything until the countdown had stopped...
If you can point me in the right direction, I'd be very grateful
Many thanks
What I would like to do is have a small 10 second countdown (starts when loaded) whereas if nothing is clicked, button1_click is called
But if any of the other buttons are clicked, the countdown stops (I can assign this code to each button)
I was trying a bit of code which invloved refreshing the userform to update the countdownTime.caption, but this would not let me click anything until the countdown had stopped...
If you can point me in the right direction, I'd be very grateful
Many thanks