O'Reilly logo

Excel 2010 Financials Cookbook by Andre Odnoha

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

Entering data via a form

Collecting information from a user is an extremely important and common function when working with financial data. It is often necessary to collect user payment information, exchange rate information, and so on. When creating calculations based on this information, it is equally important to ensure that the information is accurate and free from errors. While Excel provides some built-in validation information to prevent erroneous data, it still requires that the data be entered directly into the worksheet.

In this recipe, you will learn how to collect information from a user utilizing a code-based UserForm.

Getting ready

In order to use code and a UserForm for data entry, you will need to know what the input-location cell ...

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