Color Palette

[ExcelMonkey]

I have a userform I want to be able to put several
identical controls on it that will allow me to access the
colour palette in Excel. I want to be able to:

1) access the palette via dropdown button
2) choose a color
3) have the color show up on the dropdown button
4) and pass the color index number to a variable

I know John Walkenbach had an example of this some time
back.

Does anyone know how to do this?

Thanks

 

[Tom Ogilvy]

Here is a link to J-walks tip:

http://j-walk.com/ss/excel/tips/tip49.htm