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

Рет қаралды 14,099

11 жыл бұрын

📊 Free Workbooks: www.excelvbaisfun.com/links?u...
🥷Join Excel Ninja Pro: www.excelvbaisfun.com/ninjapr... Months FREE On Annual Plan Auto Applied)
🥷Excel Ninjas FB Group: www.excelvbaisfun.com/xlninjas (Free downloads, Trainings, Live Q&A and more)
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:
🔒 Transform Any Excel File Into A Locked EXE: www.excelvbaisfun.com/secure-... (25% off with code ‘25OFF’)
🟡 Create Custom Installers: www.excelvbaisfun.com/custom-...
👋 Business Inquiries, Consulting, Comments, etc: www.excelvbaisfun.com/contact/

Пікірлер: 9

@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 Жыл бұрын

Awesome! Check out our free vba crash course too ( www.excelvbaisfun.com/free-training ) or check out our courses ( www.ExcelNinjaPro.com ) thanks

@ExcelVbaIsFun 11 жыл бұрын

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

@excelisfun 11 жыл бұрын

Cool!

@krn14242 11 жыл бұрын

Great job.

@alexman128 8 жыл бұрын

Thanks buddy, that me.controls info is very good

@TomSaladin 11 жыл бұрын

Nice!! #24 or #26?

@haroldmcbroom7807 3 жыл бұрын

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 ???"

@decimus1447 3 жыл бұрын

declare x as integer. X is the loop counter