Business Solutions VBA and Macros for Microsoft® Office Excel® 2007

Chapter 10. Userforms—An Introduction

IN THIS CHAPTER

User Interaction Methods	177
Creating a Userform	178
Calling and Hiding a Userform	179
Programming the Userform	180
Programming Controls	181
Using Basic Form Controls	182
Verifying Field Entry	194
Illegal Window Closing	194
Getting a Filename	195
Next Steps	196

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 more complex forms.

This chapter covers simple user interface using input boxes and message boxes and the basics of creating userforms in the VB Editor. For more advanced programming, see Chapter 23, “Advanced Userform Techniques.” ...