@Numenor7

Excellent. Went from beginning to expert in one easy to follow video without fillers or ads. I didn't even need to do this but I watched the whole thing anyway.

@tritc

Thank you for sharing. The world needs people like you <3

@joestrzyzewski6007

This was really an excellent video. You framed the learning in a smart way - going from a level 1 basic way to handle the situation and then upgrading to the upper levels to make it more automated and adding features.  Your delivery was also perfect - not too fast to where I had to rewind to catch what you were demonstrating, but not too slow either where I was jumping forward to get past the basic stuff.  I will be adapting some of this code to make my spreadsheets better.  Great job

@nevadanevada6470

Really practical! You deepdive a lot in several information sources and put this all together! What an amazing result. I hope you will get a lot viewers! Thaankks a lot!

@Monochromatic_Spider

You could also make an onChange event for the worksheet that disables events (always important with these things), recalculates the totals of all colors, and then reenables events. That way the color list just updates automatically.

Also, if you really want to geek out then you could convert the color value of each cell, which is a boring old long, to be a string and use that as a key in a collection while storing the long. That way you can find unique values pretty quickly. Then it's just a matter of doing a color count for each unique color from the collection and then writing the results to a list.

@kjamison5951

I cannot think of a situation where I would need to do this BUT… that MS didn’t think to include it makes it a challenge to the brightest amongst us.

Thank you for this fascinating video!

@kdunlap3289

My daughters have been looking for a way to turn their images into "diamond art", and my sister has long used excel for mapping out her afghans. This should make estimating yarn yardages and number of "diamond dots" easier to calculate.

@garybacica5709

When I first saw how to use VBA in Excel I was a student in Dr. Zilbert's intro to business computer information systems at Hofstra. I was amazed at the potential of writing a VB macro.

@cecilm3720

So cool. Thank you for sharing.
I'm not sure what I could use it for, but I like it!!!

@quiqueenrikx3992

Simply great. Thanks 👍

@stinky_bear

This was amazing! Thank you!

@nestoreleuteriopaivabendo5415

Excellent explanations!

May I know what do you use to take these dynamic notes on your screen?

@geekatari4391

Excellent presentation. You have a new subscriber 🤓

@giuseppe3500_m2

Bravissimo, lezione interessante 😊

@paulmarixreyes5595

Is there a version of this for google sheets? This is just amazing!

@Ready_Set_Boom

Great video and explanation!

@launchexcel

What do you want to see in future videos?

✅ Watch more Excel VBA Videos here: https://www.youtube.com/playlist?list=PLjQrfrgBLzJPu8FzQD881GqV9rMx_jKBV

✅ Learn Excel Macros & VBA: https://go.launchexcel.com/macros-vba-school-vsl-youtube




Download the Free Excel Workbook
Step 1: Sign up for free: https://go.launchexcel.com/email-signup-youtube
Step 2: Log in here: https://courses.launchexcel.com/dashboard/en/login
Step 3: Download: https://courses.launchexcel.com/school/course/workbook-downloads/lecture/5612592#headline-43b69546

And you can stay logged in for quick access to future workbook downloads.

Click here for the article with full VBA code:
https://www.launchexcel.com/count-cells-by-color-5-levels (coming soon)

Chapters:
00:00 99% of Excel Users Don't Know This
00:26 Level 1: The Manual Find-and-Count Method
01:03 Level 2: Filtering Colors for Faster Counts
01:43 Level 3: Counting Colors in a Table
03:10 Level 4: Automating with VBA
04:03   ↳ How VBA Works: A Quick Tour
05:51   ↳ CountColor Function
07:15   ↳ Visual Explanation
09:07   ↳ Save It Right (not .xlsx)
09:25   ↳ The Catch?
10:01 Level 5: Refresh with a Button
12:05 Bonus: Pixel Art Color Analysis

@gintarasj.

Thank you!

@mauricelee2219

Very nice and big thanks for sharing video.

@danp6101

Here is something you can do for someone on an a birthday or another occasion.
I have done this for my daughter on her Birthday.
I took a picture of her and converted into hex values for each pixel because I didn't know about the Pixel art Addin.
I stored the hex values on hidden sheet and wrote code where it would randomly fill cells on another sheet that eventually it would Display a picture of her and It said Happy Birthday from Daddy.
She really like that, it was something special.
I see that using the Pixel Art Addin looks much easier than the way I had to do it.