Userform with two combobox dependent on one combobox

Hi,

I have looked all over the place to try and find an answer to this problem:

I have a userform that has several combobox's linked to named ranges. What I need to do is pick a value from combobox 1 and then allow combobox 2 & combobox 3 to have independent choices of named ranges dependent on only combobox 1.

I can do this very easily on an excel spread sheet using data validation and having the 3rd combobox validate with =INDIRECT(SUBSTITUTE(B5&"_Alt"," ","")), where the _Alt is given to the 3 set of named ranges as an appendment.

THis is the code I am using for the listbox, but the same applies to a combobox:

Please Login or Register  to view this content.

I want this on a userform so I can control the underlying database.

Tried that and didn't work, I have attached the spread sheet.

You will see on the MASTER tab a button to create modules that brings up the userform the second and sixth combobox's work from the first.

There are spaces in the items in the combobox and no spaces for the corresponding named range.

This removes the spaces from the selected combobox item.

Please Login or Register  to view this content.

There are also items in the combobox that do not have a named range. I don't know what you want to do in those cases.

Excellent that did the trick, simple when you know how, I just had to change one little bit of the first P1ComboBox.List, and that was to remove the & "_Alt".

Thank you very much for your help