Hi,

I have a combobox that populates based on a dynamic range in column A. I populate the combobox using the following concept:
1st, I created a named range and, using the offset command, set the reference to increase when values are added:
=OFFSET(INSPECTION!$A$3,0,0,COUNTA(INSPECTION!$A:$A)-1,1)
2nd, I populate the combobox when a userform initializes using something like:
For Each Tty_rng In ws.Range("Tty_list")
Me.Tty_box.AddItem Tty_rng.Value
Next Tty_rng
Now, this works just fine, but I want to complicate things a bit:
In column A I have certain rows of data that start and end with an asterisk. These rows are related to information from a different combobox. The following depicts what I have in Column A:

*17-PS-1*
TEST1
TEST2
TEST4
*17-PS-2*
TEST1
TEST2
*17-PS-3*
TEST1
TEST2
TEST4
*17-PS-4*
TEST

So imagine combobox1 lists 17-PS-1, 17-PS-2, 17-PS-3, 17-PS-4 (without the asterisks) and combobox2 lists the above.

What I want is, depending on what is selected in combobox1, I want the dynamic list to look for that value in the combobox2 range, and list every row until the next asterisk title is reached or the end of the rows of data is reached.

Example:
Column A lists:
*17-PS-1*
TEST1
TEST2
TEST4
*17-PS-2*
TEST1
TEST2


17-PS-2 is selected in combobox1, then combobox2 should list TEST1, TEST2.

Then, due to other parts of the userform, Column A becomes:
*17-PS-1*
TEST1
TEST2
TEST4
*17-PS-2*
TEST1
TEST2
new1
new2

I want combobox2 to now list TEST1, TEST2, new1 and new2.

Let me know if this is unclear and I can go into more detail. Thanks!