Excel 2016 VBA and Macros

10. Userforms: An Introduction

In This Chapter

Input Boxes

Message Boxes

Creating a Userform

Calling and Hiding a Userform

Programming Userforms

Programming Controls

Using Basic Form Controls

Verifying Field Entry

Illegal Window Closing

Getting a Filename

Next Steps

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.

To learn ...