O'Reilly logo

Pro Excel 2007 VBA by Jim DeMarco

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

CHAPTER 4UserForms

As skilled as we developers are at laying out a UI, when working with spreadsheets we find our options may be a bit limited. Depending on what data is being entered, you may find your users scrolling off the screen to the right or bottom of an Excel worksheet window.

UserForms in Excel 2007 allow you to create easy-to-use data entry screens for your users. They can be used to display summary data or data from any data source. They provide us with the tools we need to create "wizard" applications or simple data entry forms.

Creating a Simple Data Entry Form

Let's create a form for quick data entry for a call center doing a one-minute customer contact. The user's task is to call the customer and find out if they've heard of ...

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