VBA and Macros in Excel - Explained Top Training Company for 7th Year in a Row Previous Article Free Windows Server 2016 Clinic and Lab Next Article VBA (Visual Basic for Applications) is the programming language of Excel that allows you to automate tasks utilising what we call macros. Basically, VBA is the tool we use to develop programs to control and automate functions in Excel. Well probably the best way to understand it, is to see how it's done. How to record and then view the recorded VBA code Go to the Developer tab (If not already enabled) go to File>>Options>>Customise Ribbon>>Tick the “Developer” tab Click record Macro Once you do that you get the following pop up for Recording the Macro: This gives you the option to name, create a shortcut, store the Macro and add a description. Once you have filled in the details, click OK to start recording your first Macro. There are millions of steps and repeated procedures that you can perform for use with a Macro. When you are finished recording the steps for your Macro, click the stop Square recording button in the Code group. To Play, edit etc… Click Marcos button in the Code group Options let you add a description or to edit or create a shortcut. Edit option will let you edit the actual code in VBA for the steps you recorded in your Macro. For more on recording Macros and VBA please see our Excel Part 3 course and our Excel VBA course. You may also be interested int he following courses: Excel 2013 Programming with VBA Excel 2013 Tables, PivotTables and Conditional Formatting Excel 2013: Data Analysis with Pivot Tables Excel 2013: Data Analysis with Pivot Tables Excel 2013: Data Analysis with Power Pivot Excel 2013: Data Analysis with Power Pivot Sign up For Advanced Office Cheat Sheet Pack & Office Webinars Webinar Recordings: Tips & Tricks for Using Office 365 Microsoft Excel 2016: Creating PivotTables Getting Started with Microsoft Excel 2016 Getting Started with Microsoft Word 2016 Latest Cheat sheets: Newly updated Excel cheat sheet Updated Word cheat sheet Updated Outlook cheat sheet Popular Office shortcuts cheat sheet Windows 10 cheat sheet Web browser cheat sheet Adobe Acrobat cheat sheet More published as they become available Get access now! Wednesday, November 23, 2016 / Author: Liam Phelan / Number of views: 7776 / Comments: 0 / Print Categories:ExcelMicrosoft OfficeTech Tips Tags:Excel VBA Macros Related articles Data Visualisation with Excel & Power BI Printing from Excel - 3 useful things to know How to Import Data from PDF into Excel Excel Tips and Tricks from our Experts Excel Courses for Advanced Users