Excel vba - Getting loop to work [looping through ComboBoxes on a UserForm]

Hi I trying to get a loop to work but this is the first time I'm working with loops so need some help here
I had a code before where I populate 40 combobox's this I try to get down to one code with a loop

the code looks like this

Please Login or Register  to view this content.

My old code looked like this:

Please Login or Register  to view this content.

see the thing is I have 40 combobox and need to populate all with the same thing

Hope somebody can help

Try this revision

Please Login or Register  to view this content.

From your code it looks like you are trying to add all the rows to all 40 comboboxes

that one work like a charm