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.

✅ Download File:

☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee –

Free Excel Course (Basic to Advanced) –
Best Excel Books:

Subscribe to get awesome Excel Tips every week:

#Excel #ExcelTips #ExcelTutorial

Watch more new videos about Excel Office | Synthesized by Mindovermetal English

5/5 - (1 bình chọn)

Bài viết liên quan

Theo dõi
Thông báo của
guest
10 Comments
Cũ nhất
Mới nhất Được bỏ phiếu nhiều nhất
Phản hồi nội tuyến
Xem tất cả bình luận
Nicholas Avis

Hi,

I'm trying to figure out how to use Do While loops to copy and paste rows of data into a new worksheet. Any advice would be greatly appreciated. Thanks.

Murungi Daphine

Very well explained👍🏽

nvcworld

Very nice explained ❤️❤️❤️ but I changed something in yours code to give condition on time base but it's not working like I want to run a macro with interval of 5 mint from time 2 pm till 3 pm , really struggling for this , hope you will help me in this ❤️❤️❤️❤️

pdb gatl

Superb explained brother.

Thanks…

Abhinay Garg

Really helpful, Thanku

RAVI VERMA

Awsome way of teaching loved it

Muhammad Naeem

Hi Sumit, I am Muhammad Naeem, one of your fans from pakistan. I have a problem in writing a VB code for invoice, may you guide me….?

Kuldeep Singh

Hi Sumit, nice video again, but I have one question, what is "If _ nothing" and "if not _ nothing statement" in VBA ??

Faysal Easy Excel

Thank you so much

Kiran Zatakia

Nice, widely use function need such this kind of easy and effectively explanation, thanks for making simple