Introduction to User Interaction

In this lesson we say hi again to our friend Matt!

We also get a quick demo of:

• How to use Input Boxes to get First name and Last name from a user
• How to use an Input Box to get a Range reference from a user
• Spicing up the simple Message Box with alerts and buttons
• Using a custom User Form to create a Progress Bar to indicate how much progress has been made and how much is left remaining

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 after 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]