@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.
@Numenor7