For example, if you have to open 10 workbooks, print the documents, then close the workbook, it might take you 2 minutes with a mouse and keyboard, but with VBA it could take seconds.ĭo you ever click the wrong icons or type the wrong words? Me too, but VBA doesn’t. VBA code will operate at the speed your computer will allow, which is still significantly faster than you can operate. Since VBA code can do the same things as we could with the mouse or keyboard, why bother to use VBA at all? For example, in Excel, you can create a chart you can also create a chart using VBA, it is just another method of achieving the same thing. Most things which you can do with the mouse or keyboard in the Microsoft Office suite, you can also do using VBA. Visual Basic for Applications (VBA) is the programming language created by Microsoft to control parts of their applications. PART ONE: How to use VBA Macros What is VBA? Apply single accounting underline to selection.Fix the range of cells which can be scrolled.Turn off auto fit columns on all Pivot Tables.Resize all charts to same as active chart.

PART TWO: 30 Useful VBA codes for Excel.

Vba code learning