Dropdown lists thru Validation not friendly to Manual Text Entries

  • Thread starter Thread starter Inkheart
  • Start date Start date
I

Inkheart

Using Excel 2000.

I created a (long) dropdown list using the Validation feature. When
users go to enter data, some prefer to never touch their mouse. And
scrolling through this long list is cumbersome for everyone.

Is there a way to either autocomplete an entry based on the items in
the list?

Or to have the dropdown box "intelligently" scroll when a user types a
few characters (For instance, drop to the "S's" when he or she keys in
an 'S'?)


thanks!


(sorry if this was addressed in other posts, I really have tried
searching)
 
No, Data Validation doesn't have an AutoComplete feature, nor will it
automatically scroll as you type an entry.

Those who prefer to use the keyboard can enter the cell, then press Alt+
the down (or up) arrow to open the list. Then, use the arrow keys, or
PageUp, or PageDown keys to move through the list.
 
Hi

I have been looking how to create a dropdown box in a cell
for years on excel to input pre-determined data however
although i know it can be done i have not found a solution
yet.

Would you please help me to overcome my ignorance and let
me know how you create a drop down box.

Cheers

John
 
Well, at least I can stop wasting my time looking to get this
functionality with the validation feature.

Does anyone know if it's possible to get this "keyboard-smart"
functionality into a dropdown list using a different method?

Obviously validation is the easiest way, but I'd be open to using any
other method. I've tried playing with combo boxes and other things,
but haven't had luck yet.

(On an separate note, Debra, if you read this, thanks a BUNCH for your
information on Dependent Lists using validation. It helped me solve a
different, pesky problem.)

Regards.
 
Did you try a combobox from the control toolbox toolbar?

While still in designmode, you can show the properties of the combobox
and assign your list of valid values to the .ListFillRange
and assign your .LinkedCell to the cell holding the combobox
(if you use format|cells|number tab|custom|;;;
it'll look invisible, but you shouldn't have to change existing formulas/code)

and set the .MatchEntry to "1 - fmMatchEntryComplete"
and set the .Style to "2 - fmStyleDropDownList"

It might be closer to what you want.
 
Back
Top