UserForm with Multiple ComboBoxes Populate

Hello again everyone

Hope everyone had great holidays, I did and found time to dig in and play with VBA some more.

I am trying to figure out how to have ComboBox2 populate with data based upon the selection of ComboBox1 's Selection.

I have created a test sheet which has the code to load ComboBox1 but am not sure how to go about populating ComboBox2.
I searched the forums here and found one thread that was similar but was not sure how it worked (using collections).
Once the workbook is opened the Userform will load showing you the Primary catagory (ComboBox1)
Once you select from it, The Sub Catagory ComboBox2 will show.

All variables to be loaded into Both Combo Boxes are located on worksheet StaticVariables

I currently populate ComboBox1 by using

Please Login or Register  to view this content.

Can you provide me with some insight on how to go about doing this ?
Thank you again

Try this:

Please Login or Register  to view this content.

MSP77079,

Thank you very much for the Code, It works like a charm.