Combobox items determined by the selection in another combobox

A

Alerion

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
 
M

MontyGladstone

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
 
A

Alerion

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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top