drop down list accessed by typing the first few letters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am making a series of spreadsheets for our sales team. I have one that has
several drop down lists for those of them that do not like to type, however,
those that do type frequently want a drop down list that will be accessible
by typing the first few letters of the item, and choosing from the choices.
The drop down lists that I have are made through data validation, but is
there a macro that could let me do this programatically?
Any help would be appreciated.
 
You can use the combo box ActiveX object of the Control Toolbox toolbar to do
the "Match as you type" functionality that you want.

You can create your lists in the worksheet and when you insert the
combobox, right click on it and select properties.

The ListFillRange property is the range in the worksheet where your list is
located

The LinkedCell property is the cell that you want to recieve the selected
value

The MatchEntry property needs to be set to 1 - fmMatchEntryComplete

You'll have to add the combo boxes as needed one at a time, but you can copy
an existing one and just change the ListFillRange and the LinkedCell address.

It's a bit more work but it's much more functional than the data validation
method.
 
okay, I'm lost. I'm using 2007 Excel, which I'm still having to hit help
every time I try to find something cause it's all "iconized".
according to the instructions I found here
http://support.microsoft.com/kb/291073
I have entered a combo box. The Index is messing me up, because I want it
to index the same range?
But the properties do not come up with ListFillRange and LinkCell and
MatchEntry
Should I be inserting a VBA form into Excel instead of what I'm doing?
Sorry, It's been a long couple days and my brain is not wrapping around this.
 
Ok Kevin,
I got the properties, and got the box, changed the properties and it shows my
data. But how do I get it to allow me to type and do an autofill?
Thanks
Pam
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation drop down list query 3
Drop Down lists 2
How to dynamically change the list in drop down list based on thevalue of another cell? 1
Pick from drop-down list gives empty or erroneous result 6
EXCEL DROP DOWN 2
Drop Down Lists 2
Set Column choice to a variable from a Drop Down 4
Drop Down Lists 1

Back
Top