Macros

[ChadQue...@gmail.com]

I currently have an excel-based bonus plan. I would like to create a
macro that would request several inputs: gross sales, labor numbers,
service times, customer survey numbers, etc, and then use that data in
the existing spreadsheet. My ultimate goal would be to create a macro
that would allow even a novice excel user to open, input the data, and
then collect the results.

Any advice on how to link input boxes with existing worksheet formulas
would be greatly appreciated.

Thanks!!

[JE McGimpsey]

In article <1141510639.4...@p10g2000cwp.googlegroups.com>,
ChadQue...@gmail.com wrote:

First, take a look at data forms - they may be all you need. See "About
using the data form feature for data entry" in XL Help.

A more sophisticated approach would be to use UserForms, which can
incorporate validation, dropdowns, option buttons, checkboxes, etc.,
which can then transfer their data to a worksheet. For foolproof data
entry a UserForm is the way to go.