Hi All,

First of all, thank to them who take the time to look at this. I am currently making a database in Excel where I want to list several companies. To add a new company to the list, I want to use a userform (As given in the example file attached). Three of the fields that have to be filled out are "Super Category", "Major Category" and "Sub Category". In order not to make thousands of different names or designations, I would like to give the people choices using ComboBoxes. The purpose is to link them all three to each other. The content of Sub Category has to be based on the content of the Major Category and Major Category will, on its turn, be based on the choices made in the Super Category field.

The data with the different categories used for the ComboBoxes is located on sheet 1 in the example file attached.

For example: if a person chooses "Baby" as Super category, the only items that may appear as Major categories should be: baby food, diapers, baby wipes, formula, beby health, baby accessories and petroleum jelly.
If baby food is chosen as major category, only 'baby food jar', 'baby food dry, cereal', 'baby food toddler snacks', baby food juices' and 'O&N baby food' can appear.

The problem I have right now is with the code to link the Comboboxes and provide them with the right content. Can anyone help me on this code and tell me how I can connect the boxes and make sure that they contain the values based on each other value?

Thanks in Advance,
Thomas

Attached Files

example.xlsx (302.0 KB, 11 views)