#07. Цикл Do While ... Loop | VBA Excel
In today's lesson, we'll look at how the Do While... Loop works in VBA.
The loop is very simple. Its main purpose is to repeat the code you specify until a certain condition is met. In other words, it repeats the code you specify until the condition you specify returns True.
Video timestamps:
00:00 Start
00:07 Purpose of the Do While Loop
00:21 Basic loop structure
00:38 Simple example of a Do While Loop
01:31 Checking a condition at the end of a Do While Loop
02:11 Example of a Do While Loop for filling cells on a sheet
02:45 Exiting a Do While Loop with a button
03:43 Using Exit Do to forcefully exit a loop
Download the macro file here: https://drive.google.com/file/d/1DrjW...
Suggest a new topic for the video: https://vdsr7ufo2in.typeform.com/to/H...
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Important! This course includes a Telegram group where I answer all participant questions online and provide assistance throughout the course.
Join the group freely via the invitation link (indicated below). There is currently no limit on the number of participants.
Ask any questions you may have in this group, as part of our training. Watch the video and try to replicate it. It worked perfectly. If something doesn't work, post your question in the group. I'll answer everyone and help.
Link to the Telegram group: https://t.me/joinchat/IlKGPSggsptOHUvH
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
★ Dear friends! If you like what I do and want to support the project financially, here's the link: https://www.donationalerts.com/r/exce...
★ Let's be friends:
Facebook | / excelstore.pro
Vkontakte | https://vk.com/ExcelStore
Telegram | https://t.me/ExcelStore
#VBATraining #VBACourses #VBALessons #CookMaxim