View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
HSalim[MVP] HSalim[MVP] is offline
external usenet poster
 
Posts: 70
Default Filling a listbox

Hi,
I have added a multi-column ListBox to a user form and need to fill it with
data using VBA/ADO
the data is retrieved into a recordset from SQL Server using this statement:
rst.open "select Id, Name, Address1 from Customers where name like
'abc%'", oconn

I am looking for something like lstCustomers.rowsource = rst, which does not
work here

Thanks in advance for your suggestions.
Regards
Habib