Do Until Loop
By Richard Rost 3 months ago
Do Until Loops in Microsoft Access VBA
In this Microsoft Access tutorial, I'm going to teach you how to use a Do Until Loop in VBA. We'll discuss the pros and cons. We'll see how you can test for a condition at either the top or the bottom of the loop. We'll learn about the Exit Do command. We'll discuss how Do Until is very similar to yet different from Do While.
Members will learn how to perform goal seeking for a savings account balance using a Do Until loop. They will specify a starting balance and an end goal balance, as well as the interest rate. Then we'll use a loop to calculate the compounding monthly interest until our goal balance is met.
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!
VBA Loops Series
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Do-until Loop, do until loop, do/until loop, do until loop, VBA, exit do, Loop Counter, Conditional Exit, Loop Termination, exit out of do until loop, goal seek, monthly compounded interest, compounding interest
Subscribe to Do Until Loop
Get notifications when this page is updated