Set multiple comboboxes rowsource equal to the same multiple ranges

This is really two problems in one. First, I am trying to set the value of six comboboxes in one for loop and failing. Second, I am failing to set the rowsource of those comboboxes equal to multiple (variable) ranges. Solving these problems will solve other probles of mine as well (with textboxes, labels, etc.)

here's basically what I am trying to do, there are errors on both sides of the "="

Please Login or Register  to view this content.

or maybe like this

Please Login or Register  to view this content.

I know this is probably way off, but any help is appreciated, I searched for answers for hours. Maybe a "for each" statement?