February 10, 2014

Combo box Spin button Scroll bar for automation

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

Using a combo box, spin button and a scroll bar in an Excel worksheet¬†we can automate¬†entry of data. Next 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.