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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
The way I would do this is to click on View>Toolbars>Forms
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average Rent PSF Formula? 0
help with Sum in between dates 9
Average rent per square foot formula 1
Excel formula needed to round up a value to a whole number 5
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
create query with sum divided by another number 3
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
How do you create a series based on a specific interval? 4

Back
Top