Thank you for sharing. The world needs people like you <3
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
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!
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.
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!
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.
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.
So cool. Thank you for sharing. I'm not sure what I could use it for, but I like it!!!
This was amazing! Thank you!
Simply great. Thanks 👍
Is there a version of this for google sheets? This is just amazing!
Excellent explanations! May I know what do you use to take these dynamic notes on your screen?
Great video and explanation!
Thank you!
Excellent presentation. You have a new subscriber 🤓
Bravissimo, lezione interessante 😊
Very nice and big thanks for sharing video.
nice work
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