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
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
Take a look at John Walkenbach's color picker
http://www.j-walk.com/ss/excel/tips/tip49.htm
this should get you started.
--
Regards,
Tom Ogilvy
"Ctech" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
>
> --
> Ctech
>
>
> ------------------------------------------------------------------------
> Ctech's Profile:
http://www.excelforum.com/member.php...o&userid=27745
> View this thread: http://www.excelforum.com/showthread...hreadid=504050
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks