Excel COMBOBOX data sources  
  Index ‹ Microsoft ISV Community Center Forums ‹ Visual Basic for Applications (VBA)
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 Forums2  
 
 
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
 
 
 
Index ‹ Microsoft ISV Community Center Forums ‹ Visual Basic for Applications (VBA)