how to automatically update sql results in ActiveX Combobox?

[yingchai]

Paste the code in workbook open event which you can can see in Thisworkbook module

Hi Mohan,

I am able to make it works after copying the code into the Thisworkbook module.

If I wish to create another combo box that pulls the members from other table, what is the best way to do it? Should I declare another function in the Thisworkbook module? Eg; Private Sub Workbook2_Open() ?

Thanks.