Help with excel forms dropdown boxes?

Question

Hi there, im currently trying to make a excel form with a drop down box

The problem the drop down box i need requires about a range of about 50 within it...

And basically i was wondering whether there was a way of gettin the drop down box so you can type within it, like you see in other programs?

Any help on this would be much appreaciated..

Just to clear something up, i am aware how to do a standard drop down box.

What i need to know is, is there a way to create the drop down box so you can type within it to filter through your source list, as oppose to scrolling through it? Because scrolling through it will take time and im making the document to make my order processing quicker.

Thanks

Answer 1

It's not too hard to do. You just need to adjust the properties of your dropdown combo box.

First, you may want to change the ListRows property. By default, it is set to 8. The list rows property states the maximum number of entries that the combo box shows before it makes you start scrolling. So if your list has over 8 values you'll have to scroll down to pick it from the list. If yo set it to 20, It will show the first 20 entries on the list and 21 and greater will have to be scrolled down to be seen.

The other property that you definitely will want to change is the MatchEntry property. I recommend setting that property to:

1- fmMatchEntryComplete

This will search and reduce the list as you type the entry in like what you were talking about.

I'm assuming you know how to add items to the list.

If you have other questions feel free to ask me.

Answer 2

You may be able to create your own drop-down box using VBA (Visual Basic for Applications) but I haven't got a clue how you would do so!

If you don't get any sensible answer here, try posting your query at http://www.tek-tips.com/threadminder.cfm?pid=707

Alternatively, have a look through the search results - see source.

Answer 3

Type the list in another worksheet and then in the original worksheet, create list and use the other worksheet as its source. You can have up to 30,000 or so on your list. Its complicated to begin with but the help menu takes you step by step through it.