How can I count the number of specific shapes in excel

Greetings,

I have searched on Google but I still cannot find a solution. I am looking for some VBA code to count on different shape in different color in excel.

Example: I have 5 rectangle shapes and 3 square shapes in sheet1, I need a vba code for auto calculate the rectangle shapes when I color 2 in yellow, 3 in blue and the square shapes 1 in pink, 2 in yellow which the number will appear in cell A1 (Rectangle in yellow color), A2 (Rectangle in blue color), B1 (square in pink color), B2 (square in yellow color).

Thanking in advance.
Wiz Lee

Hi Wizlee - We really need to see the sheet in question, as shapes are usually referenced by name. Could you upload that part of your workbook?
Please remove any sensitive or extraneous info.
Try to preserve the original layout so our solutions fit your workbook.
Provide “realistic” data. Include any variations the code or formula must address.
IMPORTANT: Simulate some results to demonstrate what you want.

To attach a workbook:
Click Edit Post (or just start a new reply.)
Click Go Advanced
Scroll down to Manage Attachments and click.
Now click Browse, find your file, then click Upload. Simple!

Thank you leelnich, the excel file upload successful
My code only can count the color. I need it justify the color in different shape.

Please Login or Register  to view this content.