Step 1: Open a new Excel and go to the Developer tab then click on Record Macro from the Code section. Let’s create a macro which fills Green color in your Excel cells. Why don’t you try creating your first Excel Macro? It is as simple as using a voice recorder in your mobile phone.Ĭlick on start + record the task + click on stop = it’s done! Your macro is created! The best part is you don’t have to know anything about VB or VBA to automate a task you do in excel or to create excel macros. Set of VBA instructions = Macro = Automated task – VBA (Visual Basic for Applications) is a programming language that Microsoft Office (MS Excel, Word, Power Point, Access etc) applications uses.Īn excel macro is a set of VBA commands and functions that automates the tasks you do in excel. – A macro is a series of VBA commands and functions to perform a task.

This Introductory post/tutorial is for beginners who want to learn the basics of Excel Macros !īefore getting started with excel macros just two lines about Macros and VBA. Excel Macros or VBA Tutorial for Beginners (with Images)