In our first macro, we will display the a message in Excel using Msgbox command. The sub procedure or “sub” starts with the word Sub and ends with the words End Sub.

We will write our macro inside a sub procedure, which is like a container of code. Right click in Project Explorer -> Insert -> Module Immediate Window, go to View and select Immediate window. Properties Window, go to View and select Properties Window.

To create a Module, right click in the Project Explorer, select Insert and select Module. Our code will be held inside a Module in this section.

To access Project Explorer, go to View and select Project Explorer. To access Standard toolbar, go to View in the Menu, then go to Toolbars and select Standard. You can also, find the full, uninterrupted code for all the macros shown in the video (at the bottom of this page – refer to the Menus). This webpage provides a summary of the basic concepts as well as a commentary on the entire code. The video contains detailed explanation and walk through. This blogpost is designed to support the above Youtube video. It allows you to automate repetitive tasks, giving you options you might not have thought possible before. VBA is a great tool to enhance productivity of any corporate analyst who spends a great portion of their time in Excel. However, you do need some working knowledge of Excel.įor a more comprehensive tutorial, check out my 2.5 hour Youtube video and blogpost. In this session, we will learn how to copy data from an external file and paste it into our template file.įiles are available to download from Github. Do you want to increase your productivity in Excel? Have heard about VBA, but don’t know where to start? Learn to program using Excel VBA in just 15 mins in this compact and feature packed course.

Excel vba basics