List Box

  • Thread starter Thread starter Diana
  • Start date Start date
D

Diana

I am adding a list box to an Excel spreadsheet that
contains 140 employee names in the box. I have found that
I can't click on the drop down arrow and type the first
initial of the last name to get it to go to that area. Is
there a way to do this? This will certainly help with
data entry.

I also tried creating a list under Data, to Validation to
Settings to List and the same thing happened. I am sure
that this is something that Excel users utilize
frequently. I just don't know where to find it! Ideas
will be greatly appreciated!
 
Hi

Use a ComboBox, not a listbox. Listboxes are not for typing into.

Unfortunately, Data validation doesn't provide "autocomplete". Would be nice
if it did.
 
I added the employee list as a combobox using the Forms
toolbar. I still can't jump to a last name by typing the
first letter after clicking on the drop down arrow.
Insights anyone? I am half way there....
-----Original Message-----
Hi

Use a ComboBox, not a listbox. Listboxes are not for typing into.

Unfortunately, Data validation doesn't
Click to expand...
provide "autocomplete". Would be nice
 
Back
Top