Free Excel VBA Course #17 - Do While and Do Until Loop in Excel VBA

Описание: In this video, I will cover the Do While and Do Until loops and how to use these in Excel VBA.

A ‘Do While’ loop allows you to check for a condition and run the loop while that condition is met (or is TRUE).

There are two types of syntax in the Do While Loop.
-- Do While
-- Do Until

In this video, I show you a really simple example of how you can loop through a range of cells and fill these with numbers.

✅ VBA Course Download files: https://trumpexcel.com/course-downloa...

☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB

Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/
Best Excel Books: https://trumpexcel.com/best-excel-books/

Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexc...

-------------------------------------------------------------------------------------
00:00 - Introduction
00:29 - Do While loop syntax and structure
01:02 - Understanding the loop documentation and help
01:41 - Practical example: Selecting cells until blank
02:56 - Do Loop with condition at the end vs. beginning
03:53 - Using Exit Do to break out of loops
05:06 - Difference between Do While and Do Until
-------------------------------------------------------------------------------------

#ExcelVBA #ExcelTips #ExcelTutorial