I am adding a couple of combo boxes to my spreadsheet, one is a list of
Rules, the other combo box list items will depend upon which rule is selected.

For example if the user selects "Confined Space Entry" then the Details box
will have a list of details that only relate to that rule.

What I am thinking needs to be done is have VBA code written that will say
something like this:

if cell(A49).value = 6
then combobox123 ?????

here is where I need help. I am not a stranger to VB programming, just how
to use it with office products.

I have a separate sheet that is the storage area for all the lists that I am
using. So I am assuming that I need to make the second list box's value range
dependent upon which item is selected in list box 1.