The macros within excel They are a instruction set that are made of sequentially through a execution order. It should be noted that they can summon otherswhich allows to obtain operations as complex as necessary.
The language used for the excel macrosit is VBA (Visual Basic for Applications). Inside the tool, you will get the visual basic editorwhere you can create or maintain macros that you have available.
If you want to know how to use a macro in Excel to automate any type of taskkeep reading this step by step guide.
What kind of tasks can be automated with an Excel Macro?
One of the great benefits of using the macros in excelis that used to automate repetitive tasks. For example, if data is entered every day in a dynamic table (even if the data is different every day), it is an excellent option to start automate said task.
Another type of tasks that you can automate is when you have dates with random formats and you need to apply a unique format to them. In this sense, using a macro can be very beneficialbecause it is enough record a single macro applying the format you require and then reproduce them how many times it is necessary.
These are just a few examples of what kind of tasks can be automated with the help of a macro. But the possibilities are wide, because with them all kinds of repetitive tasks are automated to save the user time and effort.
Steps to use a previously recorded or third-party Macro in Microsoft Excel
Yes you constantly run tasks repeatedly in Excelit is recommended that record a macro to be able to automate them. However, keep in mind that the method of creation varies slightly according to operating system with whom you work.
Therefore, we will explain how to do it in Windows and macOS:
windows
Prior to start the build processyou should know that the macros and related tools VBA you find them in the Developer tab. By default it is hiddenso you must enable it.
For it:
- go to File/ Options/ Customize Ribbon.
- Once there, check the box Programmer.
After that, the procedure to record a macro is:
- Within the group Code on the Developer tabclick on record macro.
- Optionally, type the name for your macro into the box Macro name. Next, specify a shortcut key inside the box Shortcut key. Also, put a description in Description. press To accept.
- perform the actions What do you want to automate?
- On the Developer tab, click stop recording.
Finally, if you want modify a macro head to the group Code on the Developer tab. Click on macrosselect her name and click on Edit. Then it shows the Visual Basic Editor.
macOS
In the case of MacOSyou must also make sure that the Developer tab, because it is disabled by default. In order to do so, go to Excel/ Preferences/ Toolbar and Ribbon.
Within personalize ribbonon the list main tabstap on Programmer and then in Save.
Once this is done, you can record a macro as follows:
- Enter the Developer tab.
- Click on Record Macro.
- Optionally, you can write the name of the macro in Macro namespecify a shortcut key in Shortcut key and a description in Description. Then select on To accept to start recording.
- perform the actions What do you need to automate?
- Get in the group Code on the Developer taband then click stop recording.
Finally, in case you want to edit it go back to the tab Programmer. Once there, click on macrosselect the name of it and press Edit. This will open the VBA Editor. If you already have a macro previously recordedyou can work with it within Excel.
Consequently, the steps to follow to execute an already recorded macro are:
- Open the book containing the macro.
- Click on View.
- Then go into macros and then enter see macros.
- Within the list that is located in the section of Macro nameselect the macro you want to run.
- Click on Run.
Facebook Comments
Disqus