Macros

[ChadQuenneville]

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]

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!!

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.