ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   inputbox with wait (https://www.excelbanter.com/excel-programming/360700-inputbox-wait.html)

andrew

inputbox with wait
 
Hi,
I would like to write a macro that prompts for user-input with
something like an inputbox but will auto-dismiss the inputbox (or other
method of user interaction) within a certain timeperiod and go with the
default if it doesn't get a response. Is this possible?

Thanks,
Andrew


Tom Ogilvy

inputbox with wait
 
I don't think it could be easily done with an inputbox, but you could
probably do it by using a useform.

--
Regards,
Tom Ogilvy

"andrew" wrote in message
ps.com...
Hi,
I would like to write a macro that prompts for user-input with
something like an inputbox but will auto-dismiss the inputbox (or other
method of user interaction) within a certain timeperiod and go with the
default if it doesn't get a response. Is this possible?

Thanks,
Andrew





All times are GMT +1. The time now is 01:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com