![the advantages of learning visual basic for excel the advantages of learning visual basic for excel](https://www.babycenter.com/ims/2015/05/iStock_65027441_wide.jpg)
This would insert the button in the worksheet. Select the macro you want to assign to the button and click on OK.As soon as you do this, it will open the Assign Macro dialogue box. Developer tab is not visible on the ribbon by default and you may need to add it before using it.
![the advantages of learning visual basic for excel the advantages of learning visual basic for excel](https://www.excel-easy.com/smi/tutorial.png)
Go to the Developer tab –> Controls –> Insert –> Form Controls –> Button.Here are the steps to assign a macro to a button: You can assign a macro to a button and then can run the macro by simply clicking that button. While the shape is something you can format, a button has a standard format. That’s it! Now the shape would work as a button and whenever you click on it, it will run the assigned macro. In the Assign Macro dialogue box, select the macro you want to assign to the shape and click the OK button.This opens the Assign Macro dialogue box. Right-click on the shape and select the Assign Macro option.You can also insert any text in the shape by simply selecting it and typing the text. In the example above, I have changed the size, color, and border. Resize/Format the shape the way you want.It will insert the shape object in the worksheet. Insert any shape to which you want to assign the macro. In the Illustrations group, click on the Shapes icon.Even if you share the workbook with someone who has no knowledge of VBA, he/she can just click on the button and see the actions take place (without even knowing what happens in the back end). The benefit of this method is that it makes it really easy and intuitive for anyone to run the macro. One of the easiest ways to run a macro is to have a button in the worksheet and click that button to execute the macro.
![the advantages of learning visual basic for excel the advantages of learning visual basic for excel](https://img.chandoo.org/a/cost-calculation-explained.png)
Now let’s see various ways to run this macro in Excel.
#The advantages of learning visual basic for excel code#
This one line code would fill the cell A1 of the active sheet with red color. Run a Macro from the Ribbon (Developer Tab)įor the purpose of this tutorial, let’s say we have a macro named ‘ColorCell’ with the following code: Sub ColorCell().