Spin Button (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 > Spin Button
2. Now, draw the Spin Button in the empty space.
3. Now, right click on the spin button, select Format Control, and fill information as shown below and link the spin button to cell C4
Minimum Value : 0
Maximum Value : 3000
Incremental Value : 100
Cell Link : $C$4
4. Now, give it a quick test
Sample Result
