Add items to Combobox from a recordset

[ravikiran]

Dear Excel Gurus,

I have a small VBA related issue, I need help with.

I developed an excel application that interacts with an Access database. I need to copy all the distinct values in a Column from one of the tables and add them to a combobox in the form. I am using SELECT DISTINCT statement to find all the values from the column.

Can you please guide me as to how I can do the final step of adding the DISTINCT values to the combobox?

Please Login or Register  to view this content.

Thanks in advance,

cheers,
Ravi.

[Kyle123]

Please Login or Register  to view this content.

[snb]

Basically:

Please Login or Register  to view this content.

NB adapt the file's fullename

[Kyle123]

@snb, .list? I think you mean .column