@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.
@sukantacomputerengr
nice work
@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