How To Master VBA Loops In Excel - Training + Free Template

Рет қаралды 6,003

Күн бұрын

😎 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 KZfaq MEMBERS FOR UNRELEASED TRAININGS ► rebrand.ly/YTMembership_YTDesc
In this week’s training, I will share with you every aspect of Do Loops including Do While Loops, Do Until Loops as well as every other aspect of the Do Loop. By the end of this incredible training, you will become a master of Do Loops.
⬇DOWNLOAD THIS WEEK'S WORKBOOK TEMPLATE HERE:
bit.ly/DoLoops_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
2:50 - Do While Loop
5:37 - Do While Loop With Exit
7:35 - Loop While Loop
8:48 - Do Loop Until
9:37 - Loop Through Range
14:56 - Save Appointments
25:58 - Avoiding Infinite Loops
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
#exceltraining #vbatraining #DoLoops #VBALoops #DoWhileLoops

Пікірлер: 31

@ExcelForFreelancers Ай бұрын

🔥 Start Your Journey To Financial Freedom: Save Up To 65% Freelancer's Academy + Bonus Product! ► bit.ly/FreelanceAcademyYtCom

@joemanflyer2001 Күн бұрын

These are tough to understand…keep making these videos!

@ExcelForFreelancers 10 сағат бұрын

Thanks very much Joe. Much appreciated

@michaelmaharlika8569 5 ай бұрын

Even though you have taught so much and some of these are repeating, I enjoy watching them and gleaning a different perspective to your class, thanks Randy.

@ExcelForFreelancers 5 ай бұрын

That is great thanks so much. I am really glad to hear that

@myarnie1950 7 күн бұрын

Great videos Randy but why are the sub titles in Arabic, Is there a way to change this to English

@ExcelForFreelancers 7 күн бұрын

Hi and thanks for your comment. I have subtitles in 12 languages. You can change the language, or turn them off, though the video settings on your screen. I hope this helps and thanks so much.

@SyedMuzammilMahasanShahi 5 ай бұрын

Thanks for the share Randy. It's beautiful.

@ExcelForFreelancers 5 ай бұрын

For sure, you are very welcome and thanks so much Syed

@PeterLodrup 5 ай бұрын

I just have one question for you, Randy. What were you doing at Jim Carrey‘s 62nd birthday dinner?

@ExcelForFreelancers 5 ай бұрын

LOL. I did see a picture that. It looks like fun. I would have loved to be there but they did not invite me. Maybe next year :D

@momi3652 5 ай бұрын

Present for the class already....

@ExcelForFreelancers 5 ай бұрын

Thanks so much. I hope you enjoyed the training

@shaharyarahmed6124 5 ай бұрын

Masha Allah your work is so amazing

@ExcelForFreelancers 5 ай бұрын

Thank you so very much, I really appreciate that

@brokenbird2012 2 ай бұрын

Thanks for sharing Randy. For some reason I have not received the email to download this workbook.

@ExcelForFreelancers 2 ай бұрын

Hi If you have tried to download this workbook using the links but had a problem please email Shane@ExcelForFreelancers.com . Please supply the email you used along with the workbook you are requesting. Thanks for your patience.

@kalpanathakur6300 4 ай бұрын

Sir according to you what should be the way to understand VBA coding for beginners can you provide me any tips I can understand code but I am unable to write a code so can you help....

@ExcelForFreelancers 4 ай бұрын

Hi and thanks, I am happy to help. Please follow this series to start learning VBA Code: kzfaq.info/sun/PLIBeRriXvKzDTzNp5IME4-oXXCrIjvV4z I hope this helps and thanks so much.

@nishantkulkarni6668 3 ай бұрын

Hi, Following your videos and it has been a great learning experience.. preparing my own software in excel for selling now .. Just wanted to understand if any VBA code works perfectly fine in my laptop but in another laptop it is not working properly.. how to solve this issue ?

@ExcelForFreelancers 3 ай бұрын

Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.

@antonkvetnevskiy3152 5 ай бұрын

Question! How to place an excel application on the Internet so that clients can make an entry to a specific wizard on their own?

@ExcelForFreelancers 5 ай бұрын

Hi and thanks for your comment. Instead of Excel its best to use another application such as JotForm, google Form, or any other form application that will sync with Excel. I show you how to do that here: kzfaq.info/get/bejne/e6ePY9OQnqucpWQ.html I hope this helps and thanks so much.

@antonkvetnevskiy3152 5 ай бұрын

@@ExcelForFreelancers Is there an option to create an order online-form with date/time in excel and place it in some buffer?

@ExcelForFreelancers 5 ай бұрын

Excel within a browser will not function with macros, so we must use a 3rd party tool as mentioned above however I did create a basic Excel worksheet that sends data to dropbox and then can be pulled up by the desktop machine here: kzfaq.info/get/bejne/j8ephpp_tcXcl40.html I hope this helps and thanks so much.

@shaharyarahmed6124 5 ай бұрын

Sir please make a video for Pdf file view in userform

@ExcelForFreelancers 5 ай бұрын

Hi and thanks for your idea. Why is a userform necessary? (I have that here also: kzfaq.info/get/bejne/j9Okl81oqMW3o3k.html ) I hope this helps and thanks so much.

@shaharyarahmed6124 5 ай бұрын

@@ExcelForFreelancers please sir please Make a video for pdf view in userform please

@ExcelForFreelancers 5 ай бұрын

I will try to get to this in the near future. Thanks for the suggestion

@shaharyarahmed6124 5 ай бұрын

Please please please please please

@ExcelForFreelancers 5 ай бұрын

For sure, you are very welcome, you can find that here: kzfaq.info/get/bejne/j9Okl81oqMW3o3k.html