| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA code to count colors/shapes?
I've gotten great help from this group recently and am thankful. I'm
hopeful someone has an answer (or web link) for the following need. I have a worksheet that has about 100 rectangles that have been renamed to various names. Some of these rectangles are red, others blue, and so forth. Is there any VBA code that will allow me to total how many of these rectangles are red, how many are blue, then plant those figures into a cell so I can total them up and create a graph? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel document with shapes on it but the shapes do not print | Excel Worksheet Functions | |||
| Used drawing colors in shapes....lost default colors for "Fill Col | Excel Discussion (Misc queries) | |||
| How do I save pivotchart colors and shapes on data refresh? | Charts and Charting in Excel | |||
| Naming Auto Shapes and Creating new Shapes | Excel Discussion (Misc queries) | |||
| How can I loop to find the grouped shapes count | Excel Programming | |||
![Nimrod[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
