Hi all, 

Not sure if this ask is even possible but here goes…

I have a 2 column list. Column 1 contains different type of legislation (i.e. HTA, CAIA, TSSEA, etc.). Column 2 has charge descriptions available for each type of legislation. Can I have a userform with 2 Combo boxes with the first listing the different types of legislation and the 2nd being dependent on the first for charge options.

So, if HTA is selected from Combo box 1, Combo box 2 should only show the charge options from the HTA. This would sort of be like the indirect function within a spreadsheet but instead of having a new list for each type of legislation, there would only be 1 list that contains all. 

Can this be done and if so how? 

Thanks in advance!!!

​Hi all,  Not sure if this ask is even possible but here goes… I have a 2 column list. Column 1 contains different type of legislation (i.e. HTA, CAIA, TSSEA, etc.). Column 2 has charge descriptions available for each type of legislation. Can I have a userform with 2 Combo boxes with the first listing the different types of legislation and the 2nd being dependent on the first for charge options. So, if HTA is selected from Combo box 1, Combo box 2 should only show the charge options from the HTA. This would sort of be like the indirect function within a spreadsheet but instead of having a new list for each type of legislation, there would only be 1 list that contains all.  Can this be done and if so how?  Thanks in advance!!!  Read More

​