Solved: Populate a comboxbox and Listbox in a excel userform with an sql table data

[abhay_547]

Hi Tinbendr,

Brilliant. You are just awesome. I have tried the sql statement provided by you in my code in the below way and It worked exactly as I wanted.

stSQL = "SELECT DISTINCT CONVERT(VARCHAR(50), Region) FROM Region_Mapping"

Now can you please provide me with an example code which works for the below i.e .
to populate list box on the basis of Combobox selection. Suppose user selects Americas in combo box then it should show only countries of America .i.e Argentina, Brazil, Mexico etc. (which are mentioned against Americas region in country column in same sql table).

Thanks a lot once again.