Getting a combo/list box to populate based on the other

New User here,

Hopefully someone can help me try and sort a problem that my head just can't get around. I have the USer form set up and working etc. However I would like to know how to populate a combo / list box to populate based on the selection in another.

I have a worksheet with 2 colums i.e Column 1 = Report Name, Column 2= How the report is output. So in essence A2 is directly related to B2 and are dependent on nothing else.

I just can't get this working in VBE.

Any help would be greatly appreciated.

Niall