| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to color automatically color code sums in cells | Charts and Charting in Excel | |||
| How do I apply color in cells ..color now shown only in print prev | Excel Worksheet Functions | |||
| Excel 2003 will not display color fonts or color fill cells | Excel Worksheet Functions | |||
| Color Formatted Cells not showing color | Excel Worksheet Functions | |||
| My excel 2003 wont let me fill cells with color or color the tabs. | New Users to Excel | |||
![Ctech[_87_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
