How to reference a second Combo box’s output based on previous Combo Box’s Row source

Hi all,

I am looking for a way to reference a combox2 's output (which shall be a range of values pulled up from Sheet1) ; based on the combobox1's row-source and not combobox1's values

My attempt:

Please Login or Register  to view this content.

--------------------------------

See attachment if necessary