Linking List box to MS Access Table

[irresistible007]

i have a List box on Sheet1 which needs to get populated from a MS Access Document named: "LocationDB.mdb" table: "tCntry" Feild: Country Name on event Workbook_open()...

How to get around ?

 

[acw]

Hi

I did a quick search on combobox AND access and got some results that should get you going.

Here's one

http://www.mrexcel.com/board2/viewtopic.php?t=233904&highlight=combobox+access


HTH

Tony