Form controls on Excel sheet: Combo box, Spinner button and Scroll bar for automation of data entry


Form controls on Excel sheet: Using a combo box, spinner button and scroll bar in an Excel worksheet to enter data - now using the PMT function the calculations of the monthly payments have been made easier and interesting. You can also make the form more interesting by hiding various columns like the 'Car Models', the 'Prices', etc. The sheet can be protected and saved as a template. You can further use different formatting like borders to make the form more beautiful. Now using the different controls you can perform 'what-if' analysis to see how your monthly payments change when you alter the interest rate or change the model of the car, etc.

The Excel training video demonstrates the complete process.




Watch the complte video on  youtube

Form controls on Excel sheet