Help with Excel Dropdown Box VBA

[comfortablethumb]

Hello

I am currently trying to make a excel form for my small companies ordering processing, and basically what i would like to ask, is there a way to take the Excel standard drop down box, and make it so you can type within the drop down box to filter through the sources?

This problem arose because my source list is at about 173, and obviously for ease and speed it would be much easier to type within the drop down box to filter through the list, as oppose to constantly scrolling.

I have considered using just VLOOKUP and a standard coding system, but then again that would be time comsuming trying to remember the code for each of the items.

Many thanks in advance to anyone who can aid me in this matter.

Robert

 

[xlbo]

take the Excel standard drop down box

there are 3 drop down options in excel - which you use is dependant on where you are using it. By "Form" do you mean a user form or that you are arranging a worksheet to LOOK like a form ?

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Loomah]

using the control toolbox combo button with the 'matchentry' property set to 'fmmatchentrycomplete' might do the trick

;-)

If a man says something and there are no women there to hear him, is he still wrong?
How do I get the best answers?​

 

[Rofeu]

actually, there are 4 if you count the 'Pick from DropDown List' under the right-click.

From the OP's description it seems that he's taking the the OLEObject from the Forms Toolbar. (i.e. not being able to write in it).

I find that in almost all cases the ActiveX objects are much userfriendlier. Go to View --> Toolbars and choose the Control Toolbox. The combobox in there fills the the entries as you type. You can type you range in the ListFillRange property.

Cheers,

Roel