When you develop expertise in writing code in Microsoft Visual Basic for Applications (VBA) in Microsoft Excel, you can automate almost all your tasks and improve your efficiency and productivity. However, if you are a software developer, and you write code for someone else, the individual may find it difficult to execute the macros from the code window of Microsoft VBA.<\/p>\n\n\n\n
Fortunately, Excel also allows creating user forms and command buttons to execute the code. In this blog post, I will tell you how you can assign a macro\/VBA Code to a Control Button or a Command Button.<\/p>\n\n\n\n
First, create a test file and name it data.xlsm<\/strong>. Open data.xlsm<\/strong>, and press Alt+F11<\/strong> to open the VBA editor.<\/p>\n\n\n\n Under Microsoft Excel Objects<\/strong>, double click Sheet 1 (Sheet1)<\/strong>. Click Insert -> Procedure…<\/strong> and in the Name<\/strong> box, enter TestMacro<\/strong> and click OK<\/strong>.<\/p>\n\n\n\n Now enter a simple Msgbox code as shown below:<\/p>\n\n\n\n Now, we have to create a button to execute this macro. Proceed as follows:<\/p>\n\n\n\nPublic Sub TestMacro()\nMsgBox \"This macro has been executed!!\"\nEnd Sub<\/code><\/pre>\n\n\n\n