Excel COMBOBOX data sources  
Author Message
nialljsmith





PostPosted: Visual Basic for Applications (VBA), Excel COMBOBOX data sources Top

Is it possible to use access tables as datasources for excel comboboxes or for in-cell list boxes

I don't think it is but I had to ask.

To clarify. some cells in my sheets have listbox attributes. Normally the source for this is a field in the same sheet.

With a combo box, the source can be a different sheet in the Work book.

Is it possible to use an Access table as a data source for either of the aforementioned controls

Niall


Microsoft ISV Community Center Forums3  
 
 
ChasAA





PostPosted: Visual Basic for Applications (VBA), Excel COMBOBOX data sources Top

Hello Niall,

It is possible to read an Access table using ADO in Excel. I suppose then you could read the records of a table and use them for your combobox.

Chas