Waiting for user input and then continuing if none is given within a timeframe

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?
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
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.
 
Last edited:
Upvote 0

Forum statistics

Threads
1,223,895
Messages
6,175,257
Members
452,625
Latest member
saadat28

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top