VBA Combo Box with each combo box limited with the last one

Hi,

I am extremely new to VBA and have a project I am working on. I need to have four combo boxes. The first Combo Box is the driver for all the other three combo boxes.

Lets say the first combo box has two options:
1) Agent
2) Custom

The 2nd Combo Box needs to be limited based on which item is selected in the 1st Combo Box:
1) If "Agent" is selected then the following options are:
o A
o B
o C
o D
o E
o F
o G

2) If “Custom” is selected then the following options are:
o K
o L
o M
o N
o O
o P
o Q
o R
o S
o T
o U
o V
o W

The 3rd Combo Box needs to be limited based on what was selected in Combo Box 1 and Combo Box 2.
We can first work on trying to get Combo Box 2 to be limited and expand from there. Please help! So far I have the following code for Combo Box1.

Private Sub Workbook_Open()

Please Login or Register  to view this content.

For anyone who is in the same situation...I figured it out. I named the two ranges I needed the combo box to use.

Please Login or Register  to view this content.