Cascading Combo Boxes

  • Thread starter Thread starter iamamonkeysoareyou
  • Start date Start date
I

iamamonkeysoareyou

Hi!

I am trying to develop a Cascading Combo Box solution for someone.

Basically, I have one list (List A) in one Combo Box and depending on
what item in List A is chosen, the items in List B is shown.

I then want the items chosen in the combo boxes (List A and B) to
output into a specified (but not limited to) cells in a worksheet.

Please help!

Thanks,
 
Assuming you fill cboFirst with words (e.g. Oranges, Apples, Bananas) that
match the range names of the various categories (e.g. rngOranges, rngApples,
rngBananas) to appear in cboSecond, then
Private Sub cboFirst_Click()
cboSecond.ListFillRange = ActiveSheet.Range("rng" & cboFirst.Text).Address

Private Sub cboSecond_Click()
'Do something with the values in the 2 combos

NickHK
 
Back
Top