I'm not sure if "cascading combo boxes" is the correct term, but this is what I'm trying to do...

I want to have two combo-boxes, cboProduct and cboPart, such that based on what you select from cboProduct will limit the choices in cboPart.

cboProduct will contain 2 choices (A and B), and cboPart contains 4 total choices (W, X, Y and Z), that would be shortened to 2 choices based on each selection from cboProduct.
So, if you select A in cboProduct, your only options in cboPart would be W and X. Likewise, if you select B in cboProduct, your choices would be Y and Z in cboPart.

This is an extremely simplified case from what I need, but if I can get this figured out I'll be fine.

So I guess the question is: How do you link two combo boxes in vba?

If this question has already been answered and I've missed it in my search, plz post the link!

Cheers
-dkinnz