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


The InputBox function is a ...

Get VBA and Macros for Microsoft Excel now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.