List all combinations from 1 to 45

Hi,

This about an exercise, we need to visualize all possible combinations for a lottery.

The question is:

Can somebody make a VBA code which writes down all possible 6-combinations from 1 to 45.

But i would like to add a colour. And these folowing colours for each number combination.
1 rood
2 geel
3 groen
4 blauw
5 oranje
6 paars

It should be around the 40.000.000 combinations.
I added an excel sheet to give an example. But it is to much to do by hand.

Thnx