Designing the Progress Bar (User Form)

In this lesson we cover:

• How to design the Progress Bar in 3 steps
• Step 1: Create user form + labels (including aligning)
• Step 2: Format labels (color, borders, text)
• Step 3: Reposition labels (centering, using mouse)
• Plus (Step 4): We add code for UserForm_QueryClose
• How to test the UserForm by pressing F5
• How to use a breakpoint to halt code execution

Further Learning on User Forms: Excel Power Programming with VBA

If you are interested in learning more about User Forms I suggest you pick up a copy of the book “Excel Power Programming with VBA” in the Mr. Spreadsheet series published by Wiley.

When I created this course (2017) the latest edition was “Excel 2016 Power Programming with VBA” and authored by Michael Alexander and Dick Kusleika.

This book has 3 full chapters dedicated to User Forms and goes beyond the material covered in this course.

It includes details of how to get user input from User Forms as well as more advanced User Form techniques.

You will find it easier to understand the book now that you have watched me create a User Form in this module!

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]