| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Input Box Timer
Ok here's a fun one. I have an "OK Cancel input box" with a default
value already supplied. Can I have it automatically accept the default value after 10 seconds of idle Input box. Interested to see if there is a way! -Mike *** Sent via Developersdex http://www.developersdex.com *** |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Input Box Timer
It might be possible with the Windows API, but much easier to do this with a
UserForm. RBS "Michael Smith" wrote in message ... Ok here's a fun one. I have an "OK Cancel input box" with a default value already supplied. Can I have it automatically accept the default value after 10 seconds of idle Input box. Interested to see if there is a way! -Mike *** Sent via Developersdex http://www.developersdex.com *** |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Input Box Timer
Not with an inputbox, since once the inputbox is waiting for input you have
no way to control it. But you could duplicate it with a userform and do whatever you want, including setting up a timer with Excels' OnTime method. See help files for OnTime documentation and how to use it. -- - K Dales "Michael Smith" wrote: Ok here's a fun one. I have an "OK Cancel input box" with a default value already supplied. Can I have it automatically accept the default value after 10 seconds of idle Input box. Interested to see if there is a way! -Mike *** Sent via Developersdex http://www.developersdex.com *** |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to input pictures automatically based on cell input? | Excel Worksheet Functions | |||
| Stopping a Timer / Running a timer simultaneously on Excel | Excel Discussion (Misc queries) | |||
| How do I add input data in the input ranges in drop down boxes. | Excel Discussion (Misc queries) | |||
| =SUMIF(Input!H2:H718,AZ19,Input!E2:E685)AND(IF | Excel Worksheet Functions | |||
| CODE to select range based on User Input or Value of Input Field | Excel Programming | |||
Linear Mode
