Why Learn Visual Basic For Application?
Because you can use the macro recorder in Excel to record your actions in a macro and then later play them back, it can not always your need. A recorded macro can only play back each action you perform, in the same sequence, without deviation. You can always use Visual Basic for Application to enhance your recorded macro.
Click Here to start VBA Tutorial
Recorded macros are inflexible, so they cannot respond to changed or changing conditions. By adding VBA programming to your recorded macro you can give it intelligence so it can respond to changed situations. When it comes to repetitive actions within the macro itself, recorded macros are rather limited. If you want a recorded macro to repeat an action several times, you must manually repeat that action desired number of times when you record the macro. But in VBA programming you can use loops to repeat these actions. There are many circumstances under which you will want to add decision making and efficient repetition to recorded macros. The only way to get these features is to manually add VBA program statements to your recorded macro. In VBA programming you can also regularly import the database into an Excel Sheet, format the data for display, generate a chart for the data, and then print the chart and format the report.

You can also use VBA to control the execution of other applications and to automate the sharing of data between applications. There are many circumstances under which you will want to add decision making and efficient repetition to recorded macros. The only way to get these features is to manually add VBA program statements to your recorded macro. In VBA programming you can also regularly import the database into an Excel Sheet, format the data for display, generate a chart for the data, and then print the chart and format the report. You can also use VBA to control the execution of other applications and to automate the sharing of data between applications. With the help of VBA you can connect Excel to databases like SQL and Access. You can use grids and other control of VBA to create report and custom forms. You can write formula and functions of Excel in VBA programming and use the in program to generate report automatically.

Click on this link to start learning Visual Basic For Application

Microsoft Excel VBA Tutorial

Copyright www.exceltutorial.in a Microsoft Excel Tutorial and Training