{"id":12072,"date":"2024-02-02T23:00:36","date_gmt":"2024-02-02T23:00:36","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/?p=78"},"modified":"2024-02-02T23:00:36","modified_gmt":"2024-02-02T23:00:36","slug":"getting-started-with-excel-macro-1","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2024\/02\/getting-started-with-excel-macro-1\/","title":{"rendered":"Excel Macro Tutorial : What is Excel Macro ?"},"content":{"rendered":"
[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”4.16″ da_disable_devices=”off|off|off” global_colors_info=”{}” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on”][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”4.17.6″ _module_preset=”default” global_colors_info=”{}”]Dear Beginner,<\/p>\n
In this Excel Macros Tutorial<\/a>, you are going to learn the Basics of Excel Macro. This is the first Article of this Tutorial so Let’s begin with What is Excel Macro<\/strong> Let’s not get too much in detail at this point. For now, in simple language, Macro is very popular software available with the most of the windows applications. Many of the windows applications provide inbuilt Macro programming. For example: Excel, Word etc. Here in this blog you will be learning this how to use it in Microsoft Excel.<\/p>\n \nIt allows you to perform multiple operations just by clicking a simple button or changing a cell value or opening a workbook etc. It enables you to work in a smart and efficient way. In terms of productivity, it is very productive as it reduces lots of manual work and gets the things done very fast especially things which you are doing it repeatedly.<\/p>\n For now, Yes, it is very similar to Visual Basic. You don’t need to know much about the history of this language at this point of time. If you are interested and want to know history of this Language you can read this article.<\/a> It is a video tutorial,<\/a> where I have discussed about the history of this Language.<\/p>\n \nSo now, I will directly jump to my original topic, where, I am going to teach you two Important features of this Tool, which, you as a beginner, will like it the most \ud83d\ude42 Don’t get confused with these two terms which I am using Macro<\/strong> and VBA<\/strong>. It is not worth spending time on. You can consider them to be the SAME THING<\/strong> for now. You can refer my video tutorial,<\/a>, if you really want to know the difference between these two terms. In this section you will learn, how to Record Macro in Excel. Follow the below Steps one by one to record macros in Excel: Open one excel workbook. (Taken example of MS Excel 2010)<\/p>\n Go to “Developer” Tab of the workbook. (How to add Developer Tab in Excel-2010 and 2007 Workbook<\/a>)<\/p>\n Click on \u201cRecord Macro\u201d button in the right hand side of the Top Menu Bar In Excel 2007 and 2010, Macro recording can be started by clicking on the Red Shape button marked in the bottom bar of the Excel in left hand side. Click on Record Macro Button shown above In the above dialog box, enter the suitable name for this Macro. You can give the location, where you want to store this particular macro and also you can write some description about this particular to be recorded Macro. Now click OK and do some operation on the excel sheet. Like formatting of the cell or sorting some of the values etc. and click on the Stop button at the same place when you started running the Macro. I have done the above formatting and wrote few column names while recording.<\/p>\n To view this particular recorded macro, right click on any of the Sheet Name -> View Code<\/p>\n In left hand side pane, under VBA Project of that workbook, Expand the Module<\/p>\n One Module would have been created there \u201cModule 1\u201d. Click on this<\/p>\n You can see the recorded code with the given Macro Name. <\/p>\n You can Run this Recorded Macro in two ways: <\/p>\n \nBefore, I run this recorded Macro, I have deleted the formatting done during the recording of this macro. Now once I will run this Macro, then automatically that formatting will be done in that Sheet.. Magic.. Isn’t it? \ud83d\ude42 First, we will see how to run the recorded Macro by pressing the play button in VB Editor screen.<\/p>\n Here is the clean sheet : First of all, go to your VBA code screen. You would not find a play button on the workbook screen.<\/p>\n Place your cursor\/mouse within the excel macro which you want to run<\/p>\n Click on Run or Play button as highlighted in below image:<\/p>\n <\/p>\n <\/p>\n If you do not place your cursor somewhere within the VBA code which you want to run, then it will show you below popup with list of all Macros written in your workbook for your select which one you would like to run.<\/p>\n <\/p>\n If you Do not want to run the Macro, by Pressing the Run Button in the VBE screen, not to worry, you can run it from your Worksheet screen as well. Follow the below 3 simple steps to run your macro without going to the VBE screen. Press Alt + F8<\/strong> as a Shortkey. The following popup will appear (same as mentioned above) Select Your Macro from the Drop Down<\/p>\n Click on Run<\/p>\n \nThat is it!! Congratulations !! Now, you know how to Record and Play Macro in Excel Workbook.\n<\/p>\n [\/et_pb_text][et_pb_blurb title=”You may follow some tutorials here” use_icon=”on” font_icon=”||fa||400″ _builder_version=”4.17.6″ _module_preset=”0249c68e-4de8-4f44-84ff-a9b1850785b6″ hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″]<\/p>\n [\/et_pb_blurb][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n<\/span>","protected":false},"excerpt":{"rendered":" Dear Beginner, In this Excel Macros Tutorial, you are going to learn the Basics of Excel Macro. This is the first Article of this Tutorial so Let’s begin with What is Excel Macro What is Excel Macro ? Let’s not get too much in detail at this point. For now, in simple language, Macro is […]<\/p>\n","protected":false},"author":45,"featured_media":13876,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[1679],"tags":[],"class_list":["post-12072","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-macro-beginner"],"yoast_head":"\n
\n<\/p>\nWhat is Excel Macro ?<\/h1>\n
So, is it a programming language? <\/h1>\n
\nThey are <\/p>\n i) Recording a Macro <\/h3>\n
ii) Playing a Recorded Macro <\/h3>\n
Where do you find or see excel Macro or VBA code in Excel?<\/h1>\n
\nIn this tutorial, I will be taking example of MS Excel and will be exploring each and every possible technique to do the things in a very easy manner.
\n
\nIn MS Excel, we have both recording and writing our own macros based on our need. We will start with Macro recording.
\n<\/p>\nHow to Record Macro in excel<\/h1>\n
\n<\/p>\nSTEP 1.<\/h2>\n
STEP 2.<\/h2>\n
STEP 3.<\/h2>\n
\n
\n
\n<\/p>\nSTEP 4.<\/h2>\n
\n
\n<\/p>\nSTEP 5.<\/h2>\n
\n
\n<\/p>\nSTEP 6.<\/h2>\n
\nYou can also specify the shortcut key for running this particular recorded macro. It means on pressing that particular shortcut-key, this macro will automatically run.
\nTo know more about assigning short keys to your macros read this article: How to assign a Shortcut key to a Macro ?<\/a>
\nYou can also refer list of important built-in short keys in Excel here<\/a><\/p>\nSTEP 7.<\/h2>\n
\n<\/p>\nSTEP 8.<\/h2>\n
\n
\n
\n<\/p>\nSTEP 9.<\/h2>\n
STEP 10.<\/h2>\n
STEP 11.<\/h2>\n
STEP 12.<\/h2>\n
STEP 13.<\/h2>\n
\n
\n<\/p>\nHow to Run Excel Macro or VBA code in Excel<\/h1>\n
1. By Pressing Run Button <\/h3>\n
2. By Pressing a short key – Alt+F8<\/h3>\n
\n<\/p>\nHow to Run your macro by pressing the Play button?<\/h1>\n
STEP 1. <\/h2>\n
STEP 2.<\/h2>\n
STEP 3.<\/h2>\n
That is it !! You are done… and here is the result:<\/h2>\n
Important<\/h2>\n
How to run play your macro without going to VBE Screen<\/h1>\n
\n<\/p>\nSTEP 1.<\/h2>\n
\n<\/p>\nSTEP 2.<\/h2>\n
STEP 3.<\/h2>\n
\n