Code required to Auto Populate 3rd Combobox based on 02nd Combobox Selection

Hello,

I have 3 columns A,B,C and 3 combobox.

Data from Column A gets populated on 1st combobox, column B in 2nd and column C in 3rd.

Below is the code I came across that achieves this -

Please Login or Register  to view this content.

I'm looking for a code that can auto populate 3rd combobox based on what is selected in the 2nd combobox.

Have attached sample sheet

Any assistance will be helpful

Unless I'm missing something this code is doing exactly what you're asking.
If I select AA I get A1 & A2 in second combobox, Then select A1 in second combobox result in combobox1third combo) = 01A.
Code can be improved for performance on larger datasets but where is the problem ??

Hello bakerman2,

I should have been more specific.

Just as you stated, currently I have to select data from all 3 comboboxes.

Since the 3rd combobox reflects only single data, I want the 3rd combobox to automatically reflect the data in it when data from 1st two comboboxes are selected.

So, if I select AA from 1st combobox and A1 from 2nd, I want the 3rd combobox to show 01A automatically without even clicking on it.

In Secondary_Change.

Please Login or Register  to view this content.

Exactly what I required... Thanks

You're welcome but one remark.
You say combo3 only reflects single data, wouldn't it be better then to just perform search for value of combo2 in column 2 and present matching value of column 3 instead of looping and building array using redim preserve ?

Hello bakerman2,

I'm not a coder.

My requirement was to create a userform that can open specific files.

Column A contains Main File names, Column B contains file names associated with main files from column A, and Column C contains path of files from Column B.

The code which I found (including yours) populates all 3 combobox and when the command button is pressed opens the file as per the path from Column C.

I have a final thought after you provided your code (Hope my explanation makes sense)

As you stated macro should present the data from Column C. This data can be presented in a textbox or label or combobox.

Currently I press Tab 4 times to reach the command button. Can you do something so that I press Tab 3 times to reach the command button. First 2 Tabs would be to select data from 1st two combobox and the 3rd Tab should highlight the command button and when pressed enter should open the required files.

I humbly request you to go through the code from my original attachment and add code for my above explanation and simplify the code wherever required.

See if this works for you.

Perfect...Many Thanks