Improving the VBA InputBox Function

In this lesson we cover:

• A new loop – the Do Until … Loop – that keeps running code until criteria is met
• How the Do Until … Loop fixes the problem we noticed in Lesson 2 (so that the User cannot enter a blank name)
• A new problem… what happens when a user wants to close the InputBox?
• And… how to fix the new problem using labels and the GoTo command, together with using a Default setting in the InputBox

Write your comments and feedback below

• If you have questions or comments about this lesson, write it in the section below.
• Alternatively you can email the instructor Victor at [email protected]