O'Reilly logo

VBA and Macros for Microsoft Excel by Tracy Syrstad, Bill Jelen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

9UserForms—An Introduction

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required