Option buttons in Excel to perform formulas in a several Absolute.
 

I have leasing contracts where I would like to have clients select from a
four different improvement packages. When they select the improvement package
I would like Excel to calc the annual and monthly rent in each year. Each
year will have a different per sq foot cost so I have a table for that, with
5 years typically the most years.

Option buttons in Excel to perform formulas in a several Absolute.
 

The way I would do this is to click on ViewToolbarsForms
Then click and drag a dropdown box onto your worksheet.

Type your options into a range. Name the range, say MyRange.
Click on the dropdown
Format the control:
Input range: MyRange
Link Cell: G2

Assign a macro
In this macro get the value of g2 using a Select Case structure

HTH


"RangerRowe" wrote:

I have leasing contracts where I would like to have clients select from a
four different improvement packages. When they select the improvement package
I would like Excel to calc the annual and monthly rent in each year. Each
year will have a different per sq foot cost so I have a table for that, with
5 years typically the most years.