Need help populating items in combobox based on the table

[ramo114]

Hello helpers,

I have a list of country codes in a data range in Sheet10. starting with the first country code in the list, I would like to have a VBA code that would select the corresponding code. Once it is selected, a macro gets run and a calculated value in cell D10 saved to the respective column in the table.


Please help me with a VBA code that can perform the above. Please note that my country codes is large and I faced problem with a for loop. I would want something that does not operate with a loop. I do not mind type all the country codes in the VBA code.