Drop Down List with Intelligence in Excel

Question

I have a drop down list with 1000 entries.  I would like the list to get smaller based on the letters I start to type so it will be easier to select the correct entry.

Answer 1

I have a drop down list with 1000 entries.  I would like the list to get smaller based on the letters I start to type so it will be easier to select the correct entry.

You would have to use a different type of "list object".

Here's a video that shows you how:

http://www.youtube.com/watch?v=J_ORTUwmhuo

--

Biff

Microsoft Excel MVP

Well, she didn't show us how to set the autocomplete feature...

In the Properties userform select MatchEntry. In the pane on the right select 1 - fmMatchEntryComplete.

--

Biff

Microsoft Excel MVP

Answer 2

I have a drop down list with 1000 entries.  I would like the list to get smaller based on the letters I start to type so it will be easier to select the correct entry.

You would have to use a different type of "list object".

Here's a video that shows you how:

http://www.youtube.com/watch?v=J_ORTUwmhuo

--

Biff

Microsoft Excel MVP