Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combobox and data validation
Having some problems with this so I've been reviewing the "Contextures"
tutorials. With the "DataValCombobox.xls" sample file, I entered an item (in the Combo box) not on the list and when I clicked on another cell it accepted the bad name. If I try to make the same error in the validation dropdown list (not doubleclicked cell) it's not allowed. Can anyone tell me how to ensure that the combobox entries are validated when the box is left? Also, is there a way to exit the Combo box with keystrokes and not have to use the mouse to select another cell? -- Glen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
validating data in a combobox | Excel Worksheet Functions | |||
Is using data validation and comboboxes heretical? | Excel Discussion (Misc queries) | |||
ComboBox in a Data Validation List... | Excel Discussion (Misc queries) | |||
data validation vs combobox | Excel Discussion (Misc queries) | |||
Using a ComboBox for Data Entry into a Cell | Excel Worksheet Functions |