Cascading Drop Downs AND auto fill of second drop down

0

I am creating an excel spreadsheet that has cascading drop downs.  The first drop down is only 5 items but the second drop down that is produced from the first drop down can be up to 300 lines.  I am trying to figure out how to start typing in the second drop down and have the name fill in and/or reduce the number of items in the list to expedite the selection from the second list.

I am pulling the data for both drop downs from other worksheets within the same workbook.

Answer
Discuss

Answers

0
The effect you describe can be achieved with an ActiveX ComboBox when you set the properties MatchRequired = True and MatchEntry = fmMatchEntryComplete. It can't be done with Validation dropdowns. You can probably use your existing lists to load the ComboBoxes instead of validation cells.
Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login