I'm new to VBA for excel and have a question I can't quite figure out. What I'm trying to do is automatically have excel bring in the lottery numbers for that drawing and input them into labels and I also have my own numbers that I picked in labels in which I can change. What I want to do is compare them and have the matching numbers show below in another set of labels. I believe I could do it with If Then statements, but my code would be huge, it would need to check each of my numbers against the drawn numbers, and to me, there sounds like there is a better way. Maybe using a a dynamic array with looping? I'm just not sure how to accomplish that.
Any advice would be greatly apperciated! Thanks.
-Zach
Any advice would be greatly apperciated! Thanks.
-Zach