I simply need help on a study guide question. Please let me know as soon as possible. Question is as follows...
11. You want to create a scroll bar in Cell C3, which will allow the user to select a car loan amount ranging from $5,000 to $60,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 $1000 increments. The loan amount selected using the scroll bar should be displayed in Cell B3.
A B C
1 Car Loan Payment Calculator
3 Loan Amount $25,000
4 Loan Term (in years) 5
6 Annual Interest Rate 6.75%
9 Monthly Payment ($492.09)
What properties need to be changed in order to create this scroll bar, and what should these properties be set at?
Now assume you want to create a spin button in Cell C4 to allow the user to click on the arrows to change the loan term in Cell B4. The user should not be allowed to enter anything less than one or greater than 5 for the loan term. What properties need to be changed in order to create this spin button, and what should these properties be set at?