I have a userform with 2 option checks and a combo box.
each option check when checked takes put the focus of the
userform onto a sheet within an excel workbook.
each sheet has multiple columns filled with data.
The first column in each is the reference column.

When I click on one of the options how do I get the combo
box to display in it's dropdown list the references in
the fist column of the selected sheet?

The sheets are not visable to the users so the combo box
must display the reference from the correct sheet.

This has really been bugging me....
Any help would be great.
Thanks
Andy