Cascade Multiple Combo Boxes

This is for Excel 2007. I need help with VBA Combo Boxes, and Data Validation is not an option.

I need a way to cascade the multiple combo boxes from the same initial box. "Brand" is the starting box for three other combo boxes; "Furnace", "Condenser", and "Coil". I have a great script for cascading two boxes (one initial box, and one box to be filled), but I'm not sure how to adapt it to have the initial box fill three boxes) I will post the script below, as well as all relevant cell/column locations

The working script:

Please Login or Register  to view this content.

Other relevant info:

The initial combo box is populated by the brands available. Each of the combo boxes to be filled (FRN, COND, COIL) have two columns, brand and model. Each Set of columns has a different number of items, so each must have their own brand column.

FRN Brand = Column Y or 25
FRN Model = Colunm Z or 26

COND Brand = Column AB or 28
COND Model = Column AC or 29

COIL Brand = Column AE or 31
COIL Model = Column AF or 32

I hope I have included all the necessary information. Let me know if I need to add anything.

Thank you!