L
Lee Schipper
I am having trouble implementing drop-down lists in a way that is easy for a
user who is using a keyboard rather than a mouse.
Standard combo-box controls are great - a user can tab into the field, type
the first few letters of the value they want, then tab on out to the next
field in the form. Maybe 5% of the time an experienced user might need to
actually drop-down the list to find the value they want.
I want this same ability in a worksheet cell.
The combobox form control supports this (with MatchEntry =
fmMatchEntryComplete), but if I place a combobox on a cell, the user has to
click on the combobox to activate it, which is no good -- the user should be
able to tab into the cell like it is any other cell (is there an easy way
around this?)
The validation list doesn't seem to support typeahead matching -- I have to
either type in the complete value exactly right, or select the value from
the list (I am currently using Excel 2000, but I could upgrade).
Is there a way to get this functionality?
TIA!
user who is using a keyboard rather than a mouse.
Standard combo-box controls are great - a user can tab into the field, type
the first few letters of the value they want, then tab on out to the next
field in the form. Maybe 5% of the time an experienced user might need to
actually drop-down the list to find the value they want.
I want this same ability in a worksheet cell.
The combobox form control supports this (with MatchEntry =
fmMatchEntryComplete), but if I place a combobox on a cell, the user has to
click on the combobox to activate it, which is no good -- the user should be
able to tab into the cell like it is any other cell (is there an easy way
around this?)
The validation list doesn't seem to support typeahead matching -- I have to
either type in the complete value exactly right, or select the value from
the list (I am currently using Excel 2000, but I could upgrade).
Is there a way to get this functionality?
TIA!