Populating combo box using option buttons

I have two worksheets. One named TelDir which contains a telephone list data with four named ranges which are CIV, JTR and OHL the ranges being arrays of columns A to D.

On a userform I have three optionbuttons also labelled Civils, Jointers and Linesmen. Finally I have a combobox named cbxTeam.

I would like to populate the combobox using the option buttons so that when I select Civils, the Data listed in the first column (A) of sheet TelDir is listed in the combobox. Likewise when I select either of the other two categories I would like to display the other two categories of Teams in this same combobox.
Currently I can display all of the data from the four columns in this combo box but I only want to display the names (column A) of the team members.

The code I have is as follows.

Please Login or Register  to view this content.

Any ideas? I am new to this VBA malarky and am currently getting by using code from other forums and users so if there is a more efficient way of doing this, I'm all eyes

Many thanks in advance.

Alan

Instead of 3 option buttons why not use a combobox for Civils, Jointers and Linesmen?

Then you would only need one sub to populate the other combobox.