Pulling cell values into text boxes in a userform upon selecting a certain combobox value

Hi,

In general, the 'sheet' illustrated below possesses five columns: Name, Colour and Varied Scores;
...A ......B .....C ...D ...E
James .Blue ....5 ...6 ...8
Brian ..Blue ....3 ...9 ...7
Tim ....Green ..3 ...7 ...11
Sam ...Red .....5 ...5 ...5

In a userform I've created, I have two comboboxes and a single row of three textboxes; the first combobox pulls the Colour values and lists them, the second combobox pulls the Name values and lists them, and the single row of textboxes is intended for a Score to be inserted into each (3, in this example).

What I'm trying to achieve is make it so that when a Colour is selected in the first combobox, the second combobox is populated with a corresponding number of Names associated with that Colour (say for instance, when Blue is selected in the first combobox, the second combobox will list James and Brian) and then the Scores on the same row (so Blue - James - 5, 6, 8 [in three textboxes]) will populate the textboxes, and be modified within those textboxes, before saving the modifications via a Commandbutton. However, when a different name is selected in the second combobox, the textboxes empty and are populated with Scores associated with that name.

How could I go about achieving this?

Thank you in advance!