2nd combobox fill with list based on selection from 1st combobox

[dizzydunham]

I'd like to alter what populates the second combobox depending on the selection of the first combobox.

The first combobox is populated from a table range with company names. This is on a userform.(dictionary stops multiple repeats)
the second combobox is created at run time and populates from a table range with surnames.

The table has a column where company names are inputted and have multiple amounts of the same name of the companys
the next column has the surnames of the company and can have multiples of the same name.

when the user selects say - apple - in combobox1 iwould like to return all surnames in combobox 2 that are associated with apple only





any links or point of direction would be most gratefully received.

 

[Leandroarb]

Hi! See this:

Do you can use the validation with options, example A, B, C.
in other cell, insert other data validation, permission type "List" and the formula:

IF(E1="a";A1:A3,IF(E1="b",B1:B3,IF(E1="c",C1:C3)))

Therefore, when you change the first validation, the second one will change as well. And you can use named ranges.

For userforms, read this article: http://www.excel-easy.com/vba/examples/dependent-combo-boxes.html

 

[dizzydunham]

thanks for this,

its a good work through.

Ive also had another idea of tackling it and just finished reading up a little about using the advanced filter method as well, will try out 1 of these ideas hopefully tomorrow and see how it fairs.

 

[dizzydunham]

https://www.mrexcel.com/forum/excel...lters.html?highlight=visible+cells+dictionary

see link - after bouncing around and so nearly doing it - the link put all the pieces together. If your looking to use dropdown boxes to select from a column and then populate the next combobox with a reduced list selection then this could be the way you want to go.