| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How validation dropdown list open when cell is picked?.
Is there a way to cause a validation dropdown list to open immediately when
the cell is picked, rather than picking the cell and then the down-arrow? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How validation dropdown list open when cell is picked?.
You could use the selection_change event and a SendKeys command, but
that could cause unexpected results, and is usually avoided. ron wrote: Is there a way to cause a validation dropdown list to open immediately when the cell is picked, rather than picking the cell and then the down-arrow? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HELP! Nesting IF Statements/Dependent Dropdown List | Excel Worksheet Functions | |||
| Ooh .. Linking a list to a list to an output cell | Excel Discussion (Misc queries) | |||
| monitor cell that uses data validation list for change | Excel Discussion (Misc queries) | |||
| How to dynamically select a validation list from data in a cell? | Excel Discussion (Misc queries) | |||
| validation and omitting blank vaues from list | Excel Worksheet Functions | |||
Hybrid Mode
