vba combobox with data from MS Access

Hey Gerald,

I think the range of cells need to be in Excel and not Access. BUT - Using the Data Tab you can create a connection to the Access database and pull those cells into Excel. NOW that they are in Excel you can create a Combo Box by using the range they are loaded into. I'd also be looking at making that range a Dynamic Named Range so if/when the number of rows changes in your Access File the adjustment is also made in your Excel file.