Sum up all cells that contain a color
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 |
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 |
All times are GMT +1. The time now is 02:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com