Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
option buttons in excel | New Users to Excel | |||
Excel Option buttons | Excel Discussion (Misc queries) | |||
Excel Option Buttons | Excel Discussion (Misc queries) | |||
Excel option buttons | Excel Discussion (Misc queries) | |||
Excel and option buttons | Excel Programming |