ListBox property

I need to write a recordset from access to excel as a list.
To retrieve the data from access is not a problem. The question is how to fill the listbox and set the property of the field as a listbox. Any idea ? If someone as already the experience on how to write data from access to excel as a listbox, it would be very welcome.

Please Login or Register  to view this content.

Hi

Don't know how you have got the data from access, so I'll go through it all.

1) A form with a listbox called listbox1.
2) A database c:\temp\test2.mdb, with a table called access_table1 and a field called col_1
3) The form initialization code

Please Login or Register  to view this content.

The code will open the database, select the relevant details into a recordset, then from that recordset, create an array. The array is then used to provide the list to the listbox.

HTH

rylo