View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nancy Moon Nancy Moon is offline
external usenet poster
 
Posts: 3
Default Populate userform listbox from access db

I would be interested to know if there are any ideas or examples of
populating a userform listbox or combobox by extracting a dataset from
a Access database.

Rather than import data from a database into Excel worksheet, then
create a range to populate the listbox I want to use the database
directly. This enables me to update the record set separately from the
excel workbook and create sql on the fly to filter what I need.

___________________