Thread: Sum up all cells that contain a color
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default Sum up all cells that contain a color
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" wrote in
message ...

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



Reply With QuoteReply With Quote