I have requirement to populate a combobox in excel from a table in SQL when the user opens the excel workbook. Can you help me on how I can do that. Please note this is not a userform in excel. I have placed the combobox on the worksheet.

Excel Version 2010
SQL Server Version 2008

Thanks in advance