Combobox items determined by the selection in another combobox

[Guest]

Hi all

I have three comboboxes on an excel worksheet. The first combobox is easy,
as it contains a list of main categories (a range in another worksheet). User
selection from this combobox should bring up a list of subcategories in the
second combobox (four ranges in that other worksheet). And when a subcategory
is selected, a list of products should appear in the third combobox (multiple
ranges in that other worksheet). The ranges in that other worksheet are
vertical.

Ideas how to do this are very much appreciated.

Thank you

 

[Guest]

I am having the same problem, I want each selection from a drop down list to
refer to another sub-list.
Have you had any replies that have answered your problem.

Thanks

 

[Guest]

So far I have tried this, to no avail:

Private Sub cbo1Main_GotFocus()
Me.cbo1Main.ListFillRange = "cboMainList"
End Sub


Private Sub cbo1Main_Change()
Select Case Me.cbo1Main.Value
Case 1
Me.cbo1Subcat.ListFillRange = "cboSubcatList1"
Case 2
Me.cbo1Subcat.ListFillRange = "cboSubcatList2"
Case 3
Me.cbo1Prod.ListFillRange = "cboProdValitys"
Case 4
Me.cbo1Prod.ListFillRange = "cboProdMuut"
Case Else
Me.cbo1Subcat.ListFillRange = ""
Me.cbo1Prod.ListFillRange = ""
End Select
End Sub



"MontyGladstone" kirjoitti: