How To Master The For/Next Loop | Excel VBA For Beginners
ฝัง
- เผยแพร่เมื่อ 4 ก.ค. 2024
- 😎 BUILD YOUR DREAM CAREER: LEARN FREELANCING, BE YOUR OWN BOSS - UP TO 65% OFF! 👉 rebrand.ly/FreelancersAcademy...
📚 GET A DISCOUNTED DEVELOPERS LIBRARY HERE ► rebrand.ly/UDVL_YTDesc
🔥GET 300 OF MY BEST TEMPLATES HERE► rebrand.ly/300Wkbks_YTDesc
🤖BRING AI INTO EXCEL WITH THIS INCREDIBLE ADD-IN ► rebrand.ly/AIToolpack_YTDesc
👉CREATE & SELL EXCEL BASED SOFTWARE IN MY MENTORSHIP PROGRAM ► rebrand.ly/MentorshipProgram_...
▶️ GET ACCESS TO OVER 100 UPDATED TRAININGS, WORKBOOKS & PDF CODEBOOKS: rebrand.ly/Patreon_YTDesc
👨💼BECOME AN EXPERT AT DASHBOARDS ► rebrand.ly/ExcelDashboard_YTDesc
📣START LEARNING VBA HERE ► rebrand.ly/VBAEFFDan_YTDesc
🏝BECOME A SUCCESSFUL FREELANCER ► rebrand.ly/FreelancersAcademy...
⭐️JOIN TH-cam MEMBERS FOR UNRELEASED TRAININGS ► rebrand.ly/YTMembership_YTDesc
In this Excel VBA for Beginners video, we'll show you how to use the for loop in Excel to repeat a set of tasks multiple times.
For programmers who are new to Excel, the for loop is a very useful tool. The for loop allows you to repeat a set of instructions a set number of times. In this Excel VBA for Beginners video, we'll show you how to use the for loop to repeat a set of tasks multiple times. After watching this video, you'll be able to use the for loop to repeat a set of tasks multiple times in Excel!
⬇DOWNLOAD THIS WEEK'S WORKBOOK TEMPLATE HERE:
bit.ly/ForNxtLoops_WkbkDl
🤑 START EARNING BIG $$$ WITH MY AFFILIATE PROGRAM 👉 rebrand.ly/Affiliate_YTDesc
EXCEL COURSES:
►FREELANCER ACADEMY: rebrand.ly/FreelancersAcademy...
►MENTORSHIP PROGRAM: rebrand.ly/MentorshipProgram_...
►DASHBOARD MASTERCLASS: rebrand.ly/ExcelDashboard_YTDesc
►BEGINNERS VBA COURSE: rebrand.ly/VBAEFFDan_YTDesc
►WEB AUTOMATION COURSE WITH EXCEL VBA: rebrand.ly/WebAuto_YTDesc
EXCEL PRODUCTS:
►Turbocharge Your App Development: rebrand.ly/UDVL_YTDesc
►Get 300 Templates In 1 Zip File: rebrand.ly/300Wkbks_YTDesc
►Get ChatGPT Into Excel With This Addin: rebrand.ly/AIToolpack_YTDesc
►The Ultimate Excel Resource Guide: rebrand.ly/UERG_YTDesc
►Get Your Actual Employee Hourly Cost: rebrand.ly/LBC_YTDesc
►1000 Incredible Freelancing Resources: rebrand.ly/UFRG_YTDesc
🧐Find the Best Excel Products & Courses Here: rebrand.ly/ExcelProductsAndCo...
Timestamps:
0:00 - Introduction
0:25 - What is For next Loop
1:03 - Simple For Next Loop
1:15 - Simple For Loop
4:07 - Stepping Through The Code
5:02 - Loop Through Range
7:43 - Loop With Variables
10:28 - Nested For Loops
15:28 - Exiting A Loop
17:01 - Step Forward Parameter
18:52 - Step Backward Parameter
JOIN OUR COMMUNITY:
►Facebook Group: rebrand.ly/EFF_Group
►Facebook Fan Page: rebrand.ly/EFF_FanPage
Follow me on my Social Media Accounts:
🤩TikTok: / excel4freelancers
🐦Twitter: / excel4freelance
🌏Website: www.ExcelForFreelancers.com
🔗LinkedIn: / excelforfreelancers
👤Facebook: / excelforfreelancers
📸 Instagram: / excelforfreelancers
🎥Rumble: rumble.com/c/ExcelForFreelancers
✉Telegram: t.me/ExcelForFreelancers
About Us:
I help Microsoft Excel enthusiasts turn their passion into profits so they can earn passive income using their skills without having to trade time for money.
I love making these videos for you each and every week. A great way of supporting Excel For Freelancers to keep this training free each and every week is by supporting us through one of the amazing products offered that will help you skyrocket your Excel Skills and reach your dreams.
Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing here:
👉 / excelforfreelancers
New Training Video Uploaded every Tuesday!
Thank you very much for your continued support,
Randy Austin
#ExcelForFreelancers #ForNext #VBAForNext #LoopsInVBA
![[UNCUT] ฝันรักห้วงนิทรา | EP.9 (3/4)](http://i.ytimg.com/vi/ikd1tEhXbp8/mqdefault.jpg)
![ความรักไม่ได้น่ากลัวขนาดนั้น (TRUST ME) - LYKN [ OFFICIAL MV ]](http://i.ytimg.com/vi/9np-lAtCRpQ/mqdefault.jpg)
🔥 Start Your Journey To Financial Freedom: Save Up To 65% Freelancer's Academy + Bonus Product! ► bit.ly/FreelanceAcademyYtCom
boss!, i've been struggling with te syntax of a dynamic step, so say i want the loop to naturally step the row i'm currently on based on a condition, you have any tips on how i'd go about that? thx for the awesome content hope to soon enroll on the the mentorship
Just wanna take this opportunity to extend my gratitude to you, Randy. I knew nothing about Excel and once i found you, i have improved significantly. Keep up the good work! Thank you so much!!!!
Thanks so much. Very kind of you and I am really glad that i can help and share, and thanks for your continued support
Hi I m Momin from India. Thanks for all your videos. Wish multi user application. But in excel it’s not possible so kindly guide us
Hi
@khadimhussainmomin1315 To share and sync your macro-enabled Excel workbook, please watch this training: th-cam.com/video/f_1HsR9305I/w-d-xo.html
Randy, I just want to thank you for taking the time sharing your knowledge and skills with all of us.
For sure, you are very welcome Carlos, and thanks so much for your comments and continued support. I really appreciate it
Great video. Thank you!
Thank you so very much, I really appreciate that
سيد راندي يقال ان الكنوز توجد في الاوحال وانت كنز في اوحال القنوات المنتشرة على اليوتيوب.
Thank you so very much, I really appreciate that Waleed. Very kind of you
Thank you Randy, this refresher course is very enlightening 😊
For sure, you are very welcome Neren. I am happy that I can bring it to you
Im Vietnamese , This is great seri for beginner! Big thanks for your effort.
Xin Chao. For sure, you are very welcome . Cam on ban (I have lived in Vietnam for 8 years now. Beautiful Country)
Awesome stuff, as usual. Thanks so much!
Thank you so very much, I really appreciate that Hayden and glad I can help and share
Thank you soo much !!
For sure, you are very welcome and happy to help and share
Indeed grateful, Randy
Thank you so very much, I really appreciate that
Thanks Randy, another great teaching. I actually thought the mentorship program was going to be like this and work our way up to making programs with what we learned, I'll work on the mentorship program more once I get better at VBA.
Hi Michael, that sounds like a good plan. The 132 hour mentorship program would probably well over 200 hours if I was going to includes the basic VBA training, so these beginner VBA Basic lessons should help
You may want to consider enrolling in Daniel Strong’s Ultimate Excel VBA 30-hour course, in which I have secured a special discount for Excel For Freelancer Followers right here: bit.ly/VBACourseRandyShared
I hope this helps and thanks so much.
Hey Randy... Kindly make some video on accounting software using vba user form
Hi and thanks so much. I will do my best to get that done in the near future. I have a training with accounting and a userform coming up next week with a Tree View control. I hope this helps and thanks so much.
One of the best things I ever did while programming VBA, and I didn't do it long before getting laid off, was to use AutoHotKey to program to automatically put in the basics of for/next, do, select statements. I could type fornext and pooof it would transform into the perfect for next loop.
I also did a forrng which would prompt me to activate the worksheet and select the top of the range and it would automatically format a dynamic range for the fornext loop.
oh wow that is a great idea. To be honest, I have not even used the AutoHotkey potential. It can do so much more than the way I am using it. It can literally automate almost everything, not just typing. I have to take some time to explore more of its power.
Thanks again for sharing
@@ExcelForFreelancers so humble Randy. Keep it up
Thank you so much Randy for this amazing video.
For sure, you are very welcome Syed. I am glad you like the training.
Thanks a lot. You have been doing so much for us
Thank you so very much, I really appreciate that and I am happy to help and share
Thank you so much for informative and valuable video, it is very easy to understand by your lecture. Please keep it up continue.
For sure, you are very welcome and thanks so much. I am happy to help and share
Amazing video as always Sir !
Thank you so very much, I really appreciate that Sebastien. Thanks for your continued support over the years.
Hello, I have a problem, I have a sum in C3, now I want to copy it to the next column and then add a cell to the next column up to column DW, what is the best way to do this, can you give an example, thank you
Hi and thanks you can link to the cell using an absolute reference such as =$C$3 then use a relative reference for the remaining cells. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
Very informative
Thank you for the kind words! I really appreciate your support and I'm glad you found the video helpful.
Thank you very much 🙏🏽🙂
For sure, you are very welcome and I am happy to help and share
Thanks again Randy for your great explanation and video
For sure, you are very welcome Henk. I know these trainings may be a bit basic for you but I really appreciate your continued support
@@ExcelForFreelancers However, there is 1 question I have. How do I keep a good overview of the VBA section when you have created a lot of macros and how do I keep it well organized. And regarding the beginning of these lessons. It is important to experience it from the Master himself and you learn all the time. Thank you
Hi and thanks I have created a playlist for all the Basic VBA trainings here th-cam.com/play/PLIBeRriXvKzDTzNp5IME4-oXXCrIjvV4z.html
Sir in 2nd example why did you take Range as a type of variable and what is works and
After that why did you write "For Each Cell " what is mean
Hi and thanks the Range will allow us to loop through specific cells within a range and the "For Each Cell" allows the macro to check each cell in the range.
I hope this helps and thanks so much.
@@ExcelForFreelancers But in place of "For Each Cell" we can Specify the range also suppose A1:D10 then also it will go to the each cell
i am getting confusion in this
Thank you....
Hi and thanks for your feedback. I know it can be a bit complex and I will create additional videos in the near future to make that clear. I hope this helps and thanks so much.
@@ExcelForFreelancers Thank you so much sir ☺️
The most important thing has been forgotten:
At "for", the loop starts with the first value, but it changes with the "next" statement, as long as the value is between min and max, the loop is repeated with the new value.
It is therefore possible that a loop never ends if, for example, the loop variable is changed within the loop. Also: the value after exiting the loop with "next" will be outside of the last value: with "for a=5 to 7 step 2", for example, will be end with 9 and not with 7 after next!
Thanks so much for sharing. No doubt. Thank you for your Likes, Shares & Comments. It really helps.