Question: You would like to create a scroll bar in Cell C3 , which will allow the user to select a car loan amount ranging from
- You would like to create a scroll bar in Cell C3, which will allow the user to select a car loan amount ranging from $3,000 to $50,000. When you click on one of the arrows at either end of the scroll bar, you want the dollar amount to change by $100 increments. When you click between the arrows, you want the dollar amount to change by $500 increments. The loan amount selected with the scroll bar should be displayed in Cell B3.
| A | B | C | |
| 1 | Car Loan Payment Calculator | ||
| 2 | |||
| 3 | Loan Amount | $25,000 | |
| 4 | Loan Term (in years) | 5 | |
| 6 | Annual Interest Rate | 6.75% | |
| 8 | |||
| 9 | Monthly Payment | ($492.09) | |
| 10 |
What properties need to be changed in order to create this scroll bar, and what should these properties be set to?
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
