Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA and Validation Lists
Is there any way to automatically (without double clicking or clicking
the down arrow) display a list to choose from if a cell is used for validation. I have numerous cells that are "validation". Example: Cell C2 (on sheet1) is linked to a list (defined as "Styles") on sheet2 using the Data - Validation from the excel menus. A user either has to click on this cell then click the down arrow or double click the cell in order for the choices to display. I need to have it auto display (using VBA is fine) because the spreadsheet will be used on a mouseless computer. So if the user tabs over and the cell is selected, the choices will drop down, the user can use the up and down keys to highlight what they want, hit enter, then hit tab again to move on. Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA and Validation Lists
Try holding the Alt key down and then use either the up or down arrow while
in the cell with data validation. Neil "Network Admin" wrote in message om... Is there any way to automatically (without double clicking or clicking the down arrow) display a list to choose from if a cell is used for validation. I have numerous cells that are "validation". Example: Cell C2 (on sheet1) is linked to a list (defined as "Styles") on sheet2 using the Data - Validation from the excel menus. A user either has to click on this cell then click the down arrow or double click the cell in order for the choices to display. I need to have it auto display (using VBA is fine) because the spreadsheet will be used on a mouseless computer. So if the user tabs over and the cell is selected, the choices will drop down, the user can use the up and down keys to highlight what they want, hit enter, then hit tab again to move on. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation lists... | Excel Discussion (Misc queries) | |||
How to clear validation lists based on other validation lists | Excel Discussion (Misc queries) | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
Using Lists/Validation | Excel Discussion (Misc queries) | |||
Validation lists | Excel Programming |