Managing Data with Microsoft® Excel

Returning Data from a Database to a User Form

It's not always desirable to return data to a worksheet from a database. Particularly when there are many fields that you want the user to see, to edit or to otherwise respond to, you should consider putting the data in a user form.

You establish a user form by switching to the Visual Basic Editor and choosing UserForm from the Insert menu. With an empty form active, you can use the Control Toolbox to place controls—text boxes, combo boxes, option buttons, multi-page controls, command buttons, and so on—on your form.

A multi-page control is useful when you have too many fields to conveniently fit on a normal user form. When you put a multi-page control on a form, you establish two or more tabs. Each ...