I've made a macro which sums up all cells containing a certain color.
Is there a way that I can make a userform to contain a list of all the
colors (with the color itself) instead of the number?
If so how?
Thanks

Signature
Ctech
Tom Ogilvy - 23 Jan 2006 16:16 GMT
Take a look at John Walkenbach's color picker
http://www.j-walk.com/ss/excel/tips/tip49.htm
this should get you started.

Signature
Regards,
Tom Ogilvy
> I've made a macro which sums up all cells containing a certain color.
>
[quoted text clipped - 4 lines]
>
> Thanks