ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Populating a lis/combo box in excel with access data (https://www.excelbanter.com/excel-programming/278695-populating-lis-combo-box-excel-access-data.html)

Enrico Lisk

Populating a lis/combo box in excel with access data
 
i need to know how to populate a MS Excel List/Combo Boxes
with data from a MS Access table

i know how to fill excell cells with Ms Access Data

thank u

Tom Ogilvy

Populating a lis/combo box in excel with access data
 
This is an example using DAO, but once you have your recordset, the
procedure should be the same:

http://support.microsoft.com/default...23&Product=xlw
OFF97: How to Fill a UserForm ListBox with Database Values

Finally found this one: This is specific to ADO

http://support.microsoft.com/?id=244761
XL2000: How to Use ADO to Return Data to a ListBox or ComboBox

--
Regards,
Tom Ogilvy



"Enrico Lisk" wrote in message
...
i need to know how to populate a MS Excel List/Combo Boxes
with data from a MS Access table

i know how to fill excell cells with Ms Access Data

thank u





All times are GMT +1. The time now is 10:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com