Excel VBA USERFORMS #24 Using ME CONTROLS) in VBA Looping though objects controls!!

How to loop through several similar named controls to save keystrokes and automate your code. Check out this lesson!! A real time saver with dates or looping through month 1-12 or consecutive periods! Download instructions below.

Fantastic Developer Tools:

[TheSkoteinos]

Dude you are the best guy in earth rigth now, i come from python and you dont need a method over ther e! You solved a easy thing rigth on point Ty :) you win a subscriber

[ExcelVbaIsFun]

Good point. I tried re-arranging them in the best possible way on the playlist. Will have to re number them later as time allows. Oooops! thanks for the tip, TomSaladin! Dan

[alexman]

Thanks buddy, that me.controls info is very good

[haroldmcbroom]

What is x declared as in the for statement... Do I declare it as "Dim x as Control, or Dim x as Object. My version of Excel is a Student Edition, and doesn't have a data type called Control. I'm assuming that since the program runs, that it's probably been declared globally, by "Public x as ???"