| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Call popup box with pre-programmed input
HI I use this line in my macro to display a popup newnum = InputBox("Lowest allowed?", "Variation") This waits for input with a flashing cursor. Is it possible to change the code so that a zero is displayed while it waits for input? Grateful for any assistance. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Call popup box with pre-programmed input
newnum = InputBox("Lowest allowed?", "Variation", 0)
Gord Dibben MS Excel MVP On Sat, 12 Sep 2009 15:15:11 +0100, Colin Hayes wrote: HI I use this line in my macro to display a popup newnum = InputBox("Lowest allowed?", "Variation") This waits for input with a flashing cursor. Is it possible to change the code so that a zero is displayed while it waits for input? Grateful for any assistance. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Call popup box with pre-programmed input
In article , Gord Dibben
<gorddibbATshawDOTca@?.? writes newnum = InputBox("Lowest allowed?", "Variation", 0) HI Great stuff - thanks Gord. Best Wishes Gord Dibben MS Excel MVP On Sat, 12 Sep 2009 15:15:11 +0100, Colin Hayes wrote: HI I use this line in my macro to display a popup newnum = InputBox("Lowest allowed?", "Variation") This waits for input with a flashing cursor. Is it possible to change the code so that a zero is displayed while it waits for input? Grateful for any assistance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to input pictures automatically based on cell input? | Excel Worksheet Functions | |||
| Mouse wheel programmed as double-click. Office 2007 won't accept? | Excel Discussion (Misc queries) | |||
| Popup Input Box | Excel Discussion (Misc queries) | |||
| Call Center Management: How to calculate 'cost per call' | Excel Discussion (Misc queries) | |||
| How many characters can be programmed into one cell in a spreashe | Excel Worksheet Functions | |||
Linear Mode
