Step3: Go to Home tab and click on Fill Color and from the list of colors displayed click on Green. ![]() This blue button is our Start and Stop button.(Even we can directly start recording macro by clicking this button rather than going to Developer tab and then Record Macro.) (A small description about theĪs soon as you click OK, the Record Macro’s icon turns to a blue button and the same is visible at the bottom of the screen and that indicates macro has started recording means from now what ever you do in excel will get recorded. Let’s select the current workbook ie.‘ This Workbook’ĭescription : My first macro to fill Green color in cells. Store Macro in : This gives you three options to save the macro in current work book, Personal ![]() Shortcut key : For now lets leave it as blank. Macro name : GoGreen (Lets name our macro as GoGreen Remember not to use any special characters or space.) Step2: As soon as you click on Record Macro a pop-up window appears requesting you the following: ![]() 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)
0 Comments
Leave a Reply. |