Linked Comboxes Populating Multiple Textboxes

Hi

I have a user form with:
ComboBox 1
ComboBox 2
Text Boxes 1 - 12

ComboBox 1 runs through a sheet range and removes the duplicates values
ComboBox 2 is linked to Cbx1 and is populated with the second column of that range, depending upon Cbx1's value

My problems are:
Trying to populate the twelve Text Boxes with the remaining row of values.
To program those boxes to clear each time either Cbx 1 or Cbx 2 is changed.


This is the section of code I can't make work properly.
I don't raise any errors, but the TextBoxes remain blank none the less.

Please Login or Register  to view this content.

I've attached a workbook for further inspection.

If at all possible, a solution and and explanation of your answer would be greatly appreciated.

Thanks!