Cascading Combo Boxes

[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,

 

[Bob Phillips]

See http://www.xldynamic.com/source/xld.Dropdowns.html

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

 

[NickHK]

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