Introduction to User Forms

In this lesson we cover:

• The recommended 5 step process for creating User Forms to use in your VBA programs
• The mechanics of creating new User Forms in the VBA Editor
• An overview of available Controls you can add to your User Forms (including Labels, Command Buttons, ComboBoxes and more)
• Tips on moving and aligning Controls on your User Forms

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]