Microsoft Excel VBA and Macros (Office 2021 and Microsoft 365)

Chapter 10

Userforms: An introduction

In this chapter, you will:

• Use an input box to request user input

• Use a message box to display information

• Learn how to create a userform

• Add controls to the userform

• Verify a required field has an entry

• Prevent a user from closing a form

• Prompt the user to select a file

Userforms enable you to display information and allow the user to input information. Using InputBox and MsgBox controls are simple ways of doing this. You can use the userform controls in the VB Editor to create forms that are more complex.

This chapter covers simple user interfaces using input boxes and message boxes and the basics of creating userforms in the VB Editor.

Note

To learn more about advanced userform programming, see