Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

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.

exceldata-validation
MS Office Version: 2013
posted by: Troz22 on Sun Apr 16, 2017 at 2:28 pm
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.
posted by: Variatus (rep: 4889) on Sun Apr 16, 2017 at 10:23 pm
Discuss


Answer the Question

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