Can I populate a ComboBox from a SQL query?

Hi all,

I am currently pulling some simple SQL code into the worksheet, (it is a select top 10 productnames from one of our company tables). It is working perfectly, but I would like to be able to populate my ComboBox1 with the result.

I've been reading lots of tutorials and trying examples but I can't seem to get it to work for my example. I can't post the exact code as I am not sure I am allowed to give the server/database details, so I have just starred out where I have details.

Please Login or Register  to view this content.

The initial sub produces the top 10 in sheet2, but I can't seem to get it to populate the combobox. The examples online seem to all work for others but I can't get the same result

Is someone able to advise? Thanks in advance if so!

Try change to

Please Login or Register  to view this content.

It should be called from Initialize event, or OP should know how to use it somehow...

Thanks both so much! Apologies for the late reply, something came up and I wasn't allowed to
Jindon, your code seems like it wants to work.. but I am getting the error 70 - Permission Denied. Sounds like maybe it is restricted due to my companies SQL server? Or could it be something else...
NeedforExcel.. yours seems to work without error but the combobox remains empty so am confused.

The other thing I was thinking.. is because I have managed to get the query to successfully print into the sheet - could I instead write something which just fills the combobox with the rows after refreshing them? Would that be easier or would that start to delay the document (picture that it could end up with thousands and thousands of rows)?

Thanks both so much! Apologies for the late reply, something came up and I wasn't allowed to
Jindon, your code seems like it wants to work.. but I am getting the error 70 - Permission Denied. Sounds like maybe it is restricted due to my companies SQL server? Or could it be something else...
NeedforExcel.. yours seems to work without error but the combobox remains empty so am confused.

The other thing I was thinking.. is because I have managed to get the query to successfully print into the sheet - could I instead write something which just fills the combobox with the rows after refreshing them? Would that be easier or would that start to delay the document (picture that it could end up with thousands and thousands of rows)?