Lesson 3 - InputBox Function (Improved)
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]
0 comments