Excel® 2013 VBA and Macros

10. Userforms: An Introduction

In This Chapter

User Interaction Methods

Creating a Userform

Calling and Hiding a Userform

Programming the Userform

Programming Controls

Using Basic Form Controls

Verifying Field Entry

Illegal Window Closing

Getting a Filename

Next Steps

User Interaction Methods

Userforms enable you to display information and allow the user to input information. 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 more about advanced userform programming, see Chapter 22, “Advanced Userform ...