Populate Drop-Down from Database Using VBA

[Nuggets]

Populate Drop-Down from Database Using VBA

Hello,
I have a spreadsheet with 4 drop-down boxes. On open, I
would like to populate these 4 drop-down boxes with
results returned from a database query (SQL Server 2000).

Is this possible?

I've used VBA and ADO 'behind' the sheet to open a
database connection, execute a query, and return the
results, but I can't figure out now how to stick the
result set into the drop-down box.

Does anyone know how to do this?

Thanks.

 

[Tom Ogilvy]

combobox1.List = Application.Transpose(rs)

would be the first thing I tried.