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