Excel VBA Loop for the Beginners | Excel VBA Tutorials

Learn Excel VBA Loops step-by-step
Checkout Full Advanced Excel VBA Course Library: bit.ly/3tEdlRK
We Covered the following topics:
00:00 Introduction Excel VBA Loops
00:36 For Next Loop in Excel VBA
03:33 "If Else End If" nested within "For Next Loop"
08:06 Do while Loop in Excel VBA
14:40 Do Until Loop in Excel VBA
17:23 For Each Next Loop in VBA
21:09 "If End If" Nested within "For Each Next" Loop in VBA
25:11 Exercise - "Do while " and Loop Counter in Excel VBA
35:10 Example 1 "With End With" in Excel VBA
36:24 Example 2 "With End With" in Excel VBA
38:40 "Select Case" - Demonstration
40:51 "Select Case" - Explanation
Excel VBA Loop for the Beginners | Excel VBA Tutorials
#excelvba #excelmacro #excelvbaloop
Excel VBA Tutorial for Beginners - • Excel VBA Tutorial for...
Keep Yourself Updated. Follow Us Now!!!
Like us on / yodalearning
Tweet us at / yodalearning
Follow our boards at / yodalearning

[@rexbenemerito1943]

Very good tutorial. Thank you.

[@nadermounir8228]

You touched on a lot of subjects in 45 minutes only which is absolutely great

[@satishkumar-lh6kz]

This is really awesome! i am clear on all the loops now, great learning, thank you for making such a good video.

[@enricomendiola9952]

Great Video! Very well explained.

[@marcschofield6633]

Very helpful, thank you.

[@alializadeh8195]

Thank ya man

[@nadermounir8228]

Great tutorial. Always nice to learn VBA

[@user-tl5lw7rc3m]

Thank you for your effort in explaining the lessons .... Please I want to make a macro using loop to make specific values in cells based on a specific number in a specific cell

[@makarand1985]

Great teaching skills sir :) !!!

[@dougls2564]

Hello, I hope you are well. I have a question that I can not find the answer and I hope you can help. In your example "For x = 1 to 8" or for x = 1 to whatever . What if I wanted to be able to change the " 8 " element (end point) from the excel main sheet1. I am thinking like I would enter a value in a cell and the loop would run that many times. Or maybe a pull down or something. Any suggestions? Thank you

[@ca_saurabhgoyal]

You can declare upper range as inputbox and every time macro is run, user have to enter that value.
Dim i as variant
i = inputbox("Please input value")
x = 1 to i
Next x

[@dougls2564]

@@ca_saurabhgoyal Thank you. Perfect. I will research syntax for inputbox.

[@edmerzlak16]

2 questions how to start for loop in a cell other than A1, How to increment numbers by .50, I getting 6, 6.5, 7.5 ??? Thanks, Ed

[@ca_saurabhgoyal]

If you want to run macro from cell B2, then add below code before macro
Range("B2").select

[@ca_saurabhgoyal]

To increment by 0.5, need to declare variable like i = i +0.5