Okebiz Video Search



Title:Learn VBA Part 24- Do While Loop in VBA Hindi
Duration:347
Viewed:9,070
Published:28-06-2016
Source:Youtube

The Do While Loop repeats a block of code indefinitely while the specified condition continues to be met and evaluated to True, and stops when the condition turns False. The condition can be tested either at the start or at the end of the Loop. "The Do While … Loop Statements" test the condition at the start, while "The Do … Loop While Statements" test the condition at the end of the Loop. If the condition is tested at the start of the Loop, the block of code does not execute if the condition is not met initially (and the loop does not run even once) whereas if the condition is tested at the end, the Loop runs atleast once.


The Do While … Loop Statements (The condition is tested at the start, in this Loop)

Do While [Condition]

[block of code]

Loop


The Do … Loop While Statements (The condition is tested at the end, in this Loop)

Do

[block of code]

Loop While [Condition]

The Do Until loop is very similar to the Do While loop. The loop repeatedly executes a section of code until a specified condition evaluates to True.

Do While loop, you may on some occasions want to enter the loop at least once, regardless of the initial condition

There are 2 ways a Do While loop can be used in Excel VBA Macro code. You can tell Excel to check the condition before entering the loop, or tell Excel to enter the loop and then check the condition. To stop an endless loop, press ESC or CTRL+BREAK. To force an exit from a Do Until loop you use the line: Exit Do, e.g. If lNum = 7 Then Exit Do


Looping is one of the most powerful programming techniques. A loop in Excel VBA enables you to loop through a range of cells with just a few codes lines

To watch more videos and download the files visit http://www.myelesson.org
To Buy The Full Excel Course visit . http://www.myelesson.org/product or call 9752003788 10 Most Used Formulas MS Excel
https://www.youtube.com/watch?v=KyMj8...

Learn Basic Excel Skills For Beginners || Part 1
https://www.youtube.com/watch?v=3kNEv...

10 Most Used Excel Formula
https://www.youtube.com/watch?v=2t3FD...
**Most Imporant Excel Formuls Tutorials**

Learn Vlookup Formula For Beginners in Excel
https://www.youtube.com/watch?v=vomCl...

5 Excel Questions Asked in Job Interviews
https://www.youtube.com/watch?v=7Iwx4...

Create Speedometer Chart In Excel
https://www.youtube.com/watch?v=f6c93...

Learn the Basic of Excel for Beginners || Part 2
https://www.youtube.com/watch?v=qeMSV...

Create Pareto Chart In Excel
https://www.youtube.com/watch?v=2Udaj...

How to Create Dashboard in Excel
https://www.youtube.com/watch?v=RM8T1...

Excel Interview Questions & Answers
https://www.youtube.com/watch?v=Zjv1I...

SHARE TO YOUR FRIENDS


Download Server 2


DOWNLOAD MP4

Alternative Download :



SPONSORED
Loading...
RELATED VIDEOS
Excel VBA Introduction Part 15 - Do Until and Do While Loops Excel VBA Introduction Part 15 - Do Until and D...
23:07 - 152
How to use Do While and Do Until Loops in VBA for Excel (4 Examples) How to use Do While and Do Until Loops in VBA f...
11:45 - 80
Do While Loops or For Next Excel VBA Do While Loops or For Next Excel VBA
06:28 - 10
Top 25 Excel 2016 Tips and Tricks Top 25 Excel 2016 Tips and Tricks
27:44 - 117
Excel VBA - Do While Excel VBA - Do While
04:52 - 77
Advanced Excel - Creating Pivot Tables in Excel Advanced Excel - Creating Pivot Tables in Excel
13:11 - 687
Excel VBA Topic 7.3 - Do While & Do Until loops Excel VBA Topic 7.3 - Do While & Do Until loops
07:46 - 16
Learn VBA Part 9 - Use Strings in VBA Hindi Learn VBA Part 9 - Use Strings in VBA Hindi
02:49 - 17