Have you ever had to carry out the same action many times? Maybe creating 100 charts, or printing 100 documents, or changing the heading on 100 spreadsheets. But if we can get it right, then it can remove the errors created by human interaction.Ĭompletes repetitive actions without complaining: If you tell it to do the wrong things 10 times, then it will. Don’t get me wrong, you still have to program the VBA code correctly.

It will do the same task over and over again, without making any errors. 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.

Apply single accounting underline to selection PART ONE: How to use VBA Macros What is VBA?.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.

How do i use vba in excel 2016