| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
UserVal default value
res = application.Inputbox("enter value","Value Entry","My Default Value")
-- Regards, Tom Ogilvy "Brad" wrote in message ... For a UserVal prompt within VBA code, what additional lines of code would I need to insert so that if I hit the enter key without providing a value, it defaults to a predetermined value? My thanks in advance for help on this matter. Cheers! Brad |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Default Windows Profile without default Office user info | Excel Discussion (Misc queries) | |||
| Default ribbon to open by default when opening xls in browser | Excel Discussion (Misc queries) | |||
| Default Set up | Excel Discussion (Misc queries) | |||
| default value | Excel Discussion (Misc queries) | |||
| IDE default | Excel Discussion (Misc queries) | |||
Threaded Mode
