How to Insert and Run VBA Code in Excel?

How to Insert and Run VBA Code in Excel?

Last Updated : 13 Nov, 2022

In Excel VBA stands for (Visual Basic for Application Code) where we can automate our task with help of codes and codes that will manipulate(like inserting, creating, or deleting a row, column, or graph) the data in a worksheet or workbook. With the help of VBA, we can also automate the task in excel to perform all these tasks we need to insert and run the VBA code properly which we will discuss in this article.

Steps to Insert and Run VBA Code in Excel

To use the VBA code properly in Excel we need to change the default macro security settings of excel for that we need to follow further steps

Step 1: Click on the "File" menu at the left top of the excel tab.

Clicking-file-menu

Step 2: Select "Options" to get the "Excel Options" window.

Selecting-options

Step 3: Select "Customized Ribbon" in the "Excel Options" Window and then select the "Developer" check box in the "Main Tabs".

Go-to-customize-ribbon-option

Step 4: Then return to the main Excel window to select the "Developer" ribbon and then click on "Macro Security" in the "Code" group.

Selecting-developer-tab

Step 5: Click on "Macro Settings" to select "Disable all macros except digitally signed macros".

Clicking-macro-settings

Now, to insert and run the VBA in Excel so that we can write codes we need to follow further steps:

Step 1: In the main Excel window press "Alt + F11" to open Visual Basic Editor

Opening-visual-basic-editor

Step 2: Select "Sheet1(Sheet1)" in the "Project - VBAProject" tab.

Selecting-project

Then we will get a terminal where we can write the following code,

Terminal-to-write-code

Step 4: After writing a piece of code according to the user's need we need to press "F5" to run the code and then click on "Run" in the "Macro" Tab

Running-code-in-macro-tab

Then, the output of the code will be seen in the Excel sheet.

How to Insert and Run VBA Code in Excel?

A

ayushdey110

Improve

Article Tags :

Similar Reads

How to Run Code from a Module in Excel VBA

VBA Macro is for developers. In Excel, the macro is a piece of code written in VBA and VBA is Microsoft's programming language, it stands for Visual Basic for Applications. The module is a file with a .bcf extension that stores the code written in the Visual Basic for Applications editor. Let's lear

How to Add a Comment in a VBA in Excel?

VBA Macro is for developers. Macro is a piece of code written in VBA. VBA is Microsoft's programming language and it stands for Visual Basic for Applications. Let's see how to set up our VBA Macro and how to add comments in a VBA in Excel. VBA Macro Excel is a very advanced tool that contains thousa

How to Insert Dates in Excel?

In Microsoft Excel, the date can be inserted in a variety of ways, including using a built-in function formula or manually entering the date, such as 22/03/2021, 22-Mar-21, 22-Mar, or March 22, 2021. These date functions are typically used for cash flows in accounting and financial analysis. In Exce

How to Delete a Module in Excel VBA?

Have you ever seen a text file in a notepad or a source code file in visual studio code? These all are just basic files where you can write some code or information. Similarly, we have modules in excel, each module has its code window, where you can write some code and allow it to automate your repe

How to Round With Doubles in Excel VBA

The round function is used to round the floating numbers to a particular decimal value. Rounding a number, where it has a long decimal value will give a good balance between accuracy and readability. It also helps in calculation and also to get a precise result. In real life, it is useful in doing m

How to Declare and Initialize String Array in Excel VBA?

A string array is an array where we can store only string values in the array, with the help of a string array, we can store more than one string value. We can declare the string array in many ways like declaring a static string array, declaring a variant size array of string using the Array functio

How to Insert a Picture in a Cell in MS Excel?

Every day in business or any other field lots of information are there that are required to store for future use. For anyone, it is very difficult to remember that information for a long time. Earlier data and information are stored in a form of a register, file, or by paperwork but finding it may b

How to Enable & Run a Macro in Excel? 6 Ways

We can record a macro in Excel or write from scratch in VB Editor. Excel provides different options to run a macro. In this article, we explore four different approaches to running a macro in an Excel application. Even while executing an Excel macro is a straightforward process for seasoned users, i

VBA Subroutine in Excel - How to Call Sub in VBA?

When a specified action is performed on a worksheet with the help of a collection of code known as a VBA Subroutine. It also helps to read an external file, also it can open other applications from Excel. A large piece of code can be broken into small parts so that we can manage it easily. Let's lea

How to Build an Interactive Map in Excel?

An interactive map is a valuable tool for vendors, marketers, and customers. It's a map on the internet with clickable points. When you click one of the points, an informational box about that point appears. Typically, it is charts or other pertinent data. It is not only effective at executing a loc