Scrollbar (VBA)
Here we have Financial Calculator, which is calculating Future Value based on the payment, rate, years, and present value.
Here I will show you how to add a Spin Button and we will connect it to the PMT cell. When we increase or decrease the payment amount, the FV value will change automatically.
In order to add Spin Button, follow below steps:
1. Go to Developer Tab and select Insert > ScrollBar
2. Now, draw the Scrollbar in the empty space.
3. Now, right click on the scrollbar, select Format Control, and fill information as shown below and link the scrollbar to cell D4, which is Years.
Minimum Value : 5
Maximum Value : 20
Incremental Value : 1
Cell Link : $D$4
4. Now, give it a quick test
Sample Result
