@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

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

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

@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!!!

@stinky_bear

This was amazing! Thank you!

@quiqueenrikx3992

Simply great. Thanks 👍

@paulmarixreyes5595

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

@nestoreleuteriopaivabendo5415

Excellent explanations!

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

@Ready_Set_Boom

Great video and explanation!

@gintarasj.

Thank you!

@geekatari4391

Excellent presentation. You have a new subscriber 🤓

@giuseppe3500_m2

Bravissimo, lezione interessante 😊

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