codeliftsleep
Board Regular
- Joined
- Apr 14, 2017
- Messages
- 103
I'm thinking this should be possible using the Application.Wait function, but I'm wondering how you get the input to close after resuming if there is no entry?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Waiting for user input and then continuing if none is given within a timeframe
- Thread starter codeliftsleep
- Start date
PatOBrien198
Board Regular
- Joined
- Sep 13, 2017
- Messages
- 236
It depends on how you are getting the input.
If using the vba "Input()" function then it might be accomplished with a timer (Application.OnTime()) and the SendKeys function, but I've found the SendKeys to be tricky and unreliable.
Another way would be to create your own User Form, then you could set a timer and Close the form when time is up. Don't forget to kill the timer in the UserForm.Terminate event for when the user has entered some value before the timer event triggers.
If using the vba "Input()" function then it might be accomplished with a timer (Application.OnTime()) and the SendKeys function, but I've found the SendKeys to be tricky and unreliable.
Another way would be to create your own User Form, then you could set a timer and Close the form when time is up. Don't forget to kill the timer in the UserForm.Terminate event for when the user has entered some value before the timer event triggers.
Last edited:
Upvote
0
