How to create a macro in Excel 2019?

Working in Excel is so simple that we can even do multiplication . However, the amount of functions it has can complicate some tasks, but with the help of Macros we will be able to perform them without major inconvenience, that is why this article will explain how to simplify your work by creating a Macro in Excel.

Index(  )

  1. What is the function of a macro in Excel 2019?
    1. Visual Basic for Applications
  2. What types of macros can I create in Excel?
  3. Can you create a macro in each Excel workbook?
  4. How can I record a macro in Excel 2019?
    1. Enable ‘programmer’ menu
    2. Programmer menu
    3. Take action on the data
    4. Stop recording
  5. In what ways to use a macro created in Excel 2019?
    1. Apply macro
    2. Save book
  6. Can I make modifications after creating a macro?

What is the function of a macro in Excel 2019?

Macros are useful configurations to reduce repetitive tasks since they can execute a series of actions that can be customized so that the next time we are going to execute that same task, it will be enough to press the previously configured shortcut on the keyboard to start the Macro, in this way Excel will do one by one all the configured actions.

Visual Basic for Applications

Excel Visual Basic for applications that allows us to open a cell image is a language to program Microsoft Office, this unlike the main Excel software that does not allow users to manipulate it directly, VBA gives us the opportunity to master the art of creating Macros to optimize our work time in Excel.

What types of macros can I create in Excel?

There are two types of Macros that we can create in Excel, the first ones we can do through a macro recorder, once this recorder is activated, Excel will be able to record each procedure that we carry out and will store them as a process that receives the name of macro , once we finish the procedure, the process is saved and we can assign it to a button.

When pressed, this button will execute the entire procedure assigned to it. Avoiding having to repeat the same procedure over and over again, the second type of macro that we can do is better, easier to customize and execute, this is achieved by coding it using Visual Basic.

Can you create a macro in each Excel workbook?

While it is true that macros can only be used in the book where we have created it, it is also true that we can create a macro in each book that we open or create so that we can facilitate our tasks by working with information contained in more than one book, it is also possible to create a macro that can be used in several books at the same time, for which we will use the personal macro book, which is a book that does not exist by default but that we can create and use.

How can I record a macro in Excel 2019?

The main thing is to open the Microsoft Excel application , for this we must click on the start button , then in the menu we will select all the programs, we will locate the Microsoft Office folder and inside we will click on Excel.

Enable ‘programmer’ menu

Once we have the Excel application open, on the screen we must click on the ‘File’ tab that we will see in the upper left, then we go to options and there we must click on customize the ribbon, we will see A long list of options that we can enable on the right of the screen, click on the ‘Scheduler’ box and then click on ‘OK’ and we will now see a new tab called ‘Scheduler’.

Programmer menu

What corresponds now is to record a macro, let us remember that everything we will do will be recorded so it is best that we practice the commands to remember them since an error could damage all the work, then we click on the ‘Programmer’ tab and on In the ‘Code’ section we will see a button that says ‘Record Macro’, we press it to start recording a new macro.

Take action on the data

From now on, everything we do will be recorded and added to a macro, so we must enter all the commands to execute the action that we want to save as a macro and thus be able to use it later.

Stop recording

When we finish carrying out the procedure and the actions of the data that we want to store as a macro, in the same section ‘Code’ we will see a button with the name ‘Stop Recording’, we click there and the recording will end, it will also be saved.

In what ways to use a macro created in Excel 2019?

Although it is possible to create macros in Access  and even in Word, In Excel we must open the macro book if we need to use it, if we have closed the file before closing the macro, we will have to apply it, that is, we must enable the content in order to that we can store it properly.

Apply macro

First we click on ‘Enable Content’, this option will be available at the top of our Excel spreadsheet, it is in a security bar, and it will be present whenever we open a macro-enabled workbook, we apply the macro by pressing the combination of keys that we have configured, if we click on the ‘Macro’ button of the ‘Programmer’ tab and select the one we want to apply, then we click on ‘Run’

Save book

To save the workbook in macro format, we click on ‘File’ and select the option ‘Save’ and in the drop-down menu we select the option ‘Excel Workbook Enabled for Macros’, and we will have our macro stored properly.

Can I make modifications after creating a macro?

Once the macro has been saved, no modifications can be made , the only way to correct any errors in the process is by recording the commands again to save them in macro format and be able to use it.

by Abdullah Sam
I’m a teacher, researcher and writer. I write about study subjects to improve the learning of college and university students. I write top Quality study notes Mostly, Tech, Games, Education, And Solutions/Tips and Tricks. I am a person who helps students to acquire knowledge, competence or virtue.

Leave a Comment