Where is this ComboBox? Are you designing forms in the Excel VBA? If that's the case, you're sort of in the wrong forum. There's an "Office Development" forum in the main section of these VBForums. Personally, I get around just fine in VBA code, but I don't often actually develop user interfaces (i.e., Forms, Controls, etc) from the VBA. I've done it enough to know it's somewhat different from doing it in VB6 (but not monumentally different).

Also, just for clarification. You say you're in Excel. But, you're not using an Excel spreadsheet (worksheet) for anything, correct? We're just talking about getting data from a MS-Access table into the dropdown list of a combobox.

You might consider doing your VBA work from Access rather than Excel. That way, you could rather trivially design a form with ComboBoxes that were easily bound to any table's field. When you add one of these combos to a form, the wizard immediately asks you which table and field is to be used for the dropdown data. Can't get much easier than that.

Good Luck,
Elroy