Excel VBA Code
VBA or also known as Visual Basic Applications is a programming language for excel and not only excel but for most of the Microsoft office programs. We can write set of instructions in a visual basic editor which performs certain tasks for us is known as code in VBA.
In Excel, VBA can be found under the developer tab as it is meant for developers, to access the developer’s tab we need to enable it first and then we can access it from the tab or by the keyboard shortcut ALT + F11. A combination of codes makes a procedure which is also known as macros in VBA, so in other words, macros are a set of codes which is a programming language written together.
If you are new to VBA and you have no idea about it then this article is for you.
Enable Developer Tab
First thing you need to do is to make sure that the developer tab in excel is visible on ribbon.
If your excel is not showing Developer tab then follow the below steps to enable the developer tab in your excel.
Step 1: Go to File.
Step 2: Click on Options.
Step 3: Go to Customize Ribbon in excel.
Step 4: Check the Developer tab on the right side. Once you select the options click on OK.
Examples to Use Excel VBA Code
#1 – Paste Code in Module
To write VBA code, the first thing you need to do is go to the Developer tab and click on Visual Basic.
You can also press the excel shortcut key “ALT + F11” to open the Visual Basic.
As you open the visual basic you will see a window like the below.
Go to Insert and click on Module.
As soon as you click on the module it will be inserted and you can see the Module name and also you will see a white plain board on the right.
4.6 (247 ratings) 3 Courses | 12 Hands-on Projects | 43+ Hours | Full Lifetime Access | Certificate of Completion
In the white plain board, you need to paste your copied code.
After pasting the code, you need to execute it.
We can conduct the execution process in two ways one is by pressing the shortcut key F5 or else by clicking the green run button on the top.
The copied VBA code will be executed in your window.
#2 – Save the Workbook with VBA Code
I know you don’t need any special introduction to save the excel file, but when it comes to VBA code contained excel workbook you need one special introduction.
If the workbook is already saved and you just copied VBA code then you need to change the file extension because when you click on save option you will see below alert message.
This says the workbook you are trying to save contains a VB project, cannot be saved as a normal excel workbook. You need to save this workbook as a “Macro-Enabled” workbook.
Click on Save As or press F12 key, you will see below a window.
Enter the file name as per your wish but select the Save as type “Excel Macro-Enabled Workbook (*.xlsm)
Click on OK to save the workbook as Macro-Enabled Workbook.
#3 – Assign Macro Code to Shapes
Whenever we need to run VBA, we need to go back to the visual basic editor and run, this is a time-consuming process.
We can assign a macro by its name to one of the shapes. Follow the below steps to assign the excel macro to shapes.
Step 1: Go to Insert and select the shape as per your wish.
Step 2: After selecting the shape to draw this on your worksheet. Ideally away from the data.
Step 3: Right-click and select Edit Text.
Step 4: Add the word as per your wish. I have added the word as “Click Here to Run the Macro”.
Step 5: Again right-click and select the option to assign a macro.
Step 6: Now we will see all the macro list. Select the macro name you wish to assign.
Step 7: Click on OK. Now, this button holds the macro code. Whenever you click on this button this code will be executed.
This has been a guide to VBA Code. Here we learn how to Copy, Insert & Run the VBA Code in Excel along with simple and practical examples. Below are some useful excel articles related to VBA –