VBA and Macros for Microsoft Excel

9UserForms—An Introduction

IN THIS CHAPTER

User Interaction Methods

Creating a Userform

Calling and Hiding a Userform

Case Study: Bug—Adding Controls to an Existing Form

Using Basic Form Controls

Using the Multipage Control to Combine Forms

Next Steps

User Interaction Methods

User forms allow you to display information and allow the user to input information. InputBox and MsgBox are simple ways of doing this; the UserForm controls in the VBE can be used to create more complex forms.

This chapter covers simple user interface using InputBoxes and Messageboxes and the basics of creating UserForms in the VBE; for more advanced programming, see Chapter 21, “Advanced UserForm Techniques.”

InputBox

The InputBox function is a ...