For some time Excel has allowed us to assign a recorded macro to a command button in Excel, this greatly facilitates our work, because it allows us to make a large number of configurations with the press of a key.
This option has been around for just over a decade, but it has been with the increasing use of spreadsheets by businesses and administrators that some features have been discovered in order to make work easier and faster to do.
Macros have become an essential tool for those who create statistics, calculation tables, who carry inventories of large establishments or need to make an Excel spreadsheet to calculate rental prices.
This current fame has led some developers to create macros and share them, which in turn allows other users to download and get hold of them.
Macros become a necessity when it comes to working quickly because they will take productivity to the maximum, we can apply macros to any spreadsheet. They are similar to the best most useful keyboard shortcuts to use in Excel, just not exactly.
Assigning a button is something that gives us a few seconds of time, which generally goes into organizing and defining what we will do with the cells, but with this, it is just a matter of selecting the cells and clicking this button so that everything is done in a right now.
In turn, it is possible to create a custom progress bar while executing a macro in Excel, so that there is no loss along the way.
If you already have Excel on your computer, you must start a new spreadsheet and follow these steps:
Check the Developer box
Add the ” Developer ” tab to the Options bar, you must enter the ” File ” section, once there locate the ” Options ” item and click on it, finally go to the ” customize ribbon ” section and mark the ” Developer ” box.
Create the button to which you want to link the macro, for this you must go to the ” Developer ” tab and look for the ” Controls ” section while there click on ” Insert ” and you must click on the first small box that says ” Button ” in the ” Form Controls ” section.
Give the button the size and location that you like the most, it can go where you want and have the size of your choice. It remains in your imagination what you can do with this button.
Assign macro
Immediately after completing the previous step, Excel will ask you to assign a macro for this button, there select the macro you want to link and press ” OK “.
Define the format
Prevent the button from losing its location and size by assigning a format, to do this, right-click on the button and look at the end of the list for the option ” Control Format “.
This will display a menu where you must locate the option ” Properties “, now check the box ” Do not move or change size with cells “, finish by pressing ” OK ” so that your selection is saved.
Give your button a name and this will facilitate the selection when you are working, this makes it faster and helps you remember which macro this button is associated with.
Now you have managed to assign a recorded macro to a button, this works for you in a large number of circumstances, being able to use it in any sheet you create, which leads you to do the job efficiently and quickly.
This also helps reduce the time it takes to complete a task because perhaps something can take hours can be done in a matter of seconds with a single click.
The most time-consuming part of this is the creation of the macro and the buttons, but the functionality is so extensive that this investment of time gains some need to increase our productivity.
We hope then that this tutorial is of interest to you and that it helps to increase the amount of skills that you can offer to your company or your future employers.