hi good day

i have two workbooks, the one is used as a register the second has a form with some comboboxes. i want :
1. the combobox on the form to be go look in the 1st workbook at a specific column,
2. take all the unique values in that column, and
3. populate the combobox with those values.

it can either be an open workbook or closed workbook, i know application.events = false or true will open that workbook with out the user knowing it opened then close it again.

any assistance would be appreciated....