Lesson 2. About VBA Editor

About VBA Editor

The first step to working with VBA in excel is familiarized with the Visual Basic Editor also called the VBA Editor, VB Editor or VBE Editor.

Visual Basic Editor is a separate application. It is a part of Excel and opens whenever you open an Excel workbook. By default, it is hidden and you have to activate to access it.

Visual Basic for Applications Editor is a very powerful tool. It is an interface for creating scripts.

VBA Editor is the place where you keep the VBA code.

There are multiple ways to get the code in the VBA Editor, Such as:

1. When you record a Macro, It creates a new module in the VBA Editor automatically and inserts the code in that module.

2. You can manually write VBA code in VBA Editor.

3. Also, you can copy a code from some other workbook or some other source such as the internet and paste it in the VBA Editor.

Access the VBA Editor

There are various ways to access or open the Visual Basic Editor in VBA, such as:

1. Using a keyboard shortcut ( Easiest and Fastest).

2. Using The Worksheet Tab.

3. Using The Developer Tab 

1. Using a keyboard shortcut

Let's see how to access the VBA Editor using a keyboard shortcut such as:

This is the easiest way to access the VBA Editor to use the keyboard shortcut, i.e. hold the Alt Key and press the F11 key (Alt + F11).

It opens a separate window for the Visual Basic for Application Editor.

This shortcut works as a toggle. Therefore when you use it again, it will take you back to the Excel application.

2. Using The Worksheet Tab

Let's see how to access the VBA Editor using the worksheet tab step by step, such as:

This is the less used method to open the Visual Basic for Application Editor.

Step 1 : Go to the Worksheet Tab

Step 2 : Right Click on the Tab

Step 3 : Then, Click on "View Code" Option

Step 4 : It will open the VBA Editor and also open the code window to that worksheet object.

This is very useful when you want to write code works only for a specific worksheet. This is usually 

happening with worksheet events.

3. Using the Developer Tab

Let's see how to access a VBA Editor step by step, such as:

Step 1 : First Go to Excel window.

Step 2 : Click on "File Menu".

Step 3 : Click on Options Button. 

Step 4 : Click on the Customize Ribbon Button.

Step 5 : Select the Developer Checkbox, as shown in the below screenshot.

Step 6 : Then click on the OK button.

Step 7 : Now, you will be able to see the Developer tab in the Ribbon.

Step 8 : Select the Visual Basic option or press Alt + F11 shortcut key.

Step 9 : It will open a VBA window shown in the below screenshot.

 

Happy Learning

Thanks for Visit This Post. Computer Related Any Query Please Contact Us.

Call / WhatsApp: +91 9650597419 (Vinay Sir)

-----------------------------------------------------------------------------------------------------------------------------

ALL COMPUTER PDF NOTES AVAILABLE IN HINDI & ENGLISH MEDIUM

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

COMPUTER NOTES FOR TEACHERS AVAILABLE IN HINDI & ENGLISH MEDIUM

Dear Teachers ऐसा कंप्यूटर नोट्स जिसे आप पढ़कर बच्चों को आसानी से पढ़ा सकते हैं। यह नोट्स केवल कंप्यूटर इंस्टिट्यूट एवं टीचर्स के लिए हैं। इस नोट्स में आप अपना Watermark, Header / Footer और या Logo भी लगा सकते हैं। यदि आपको नोट्स खरीदने से रिलेटेड कोई भी problem आती है तो आप हमें Call या WhatsApp कर सकते हैं। Call / WhatsApp: +91 9650597419

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

COMPUTER PDF NOTES IN ENGLISH

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

COMPUTER PDF NOTES IN HINDI

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

BASIC COMPUTER PDF NOTES IN ENGLISH

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

BASIC COMPUTER PDF NOTES IN HINDI

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

MS WORD PDF NOTES IN ENGLISH

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

MS WORD PRACTICE ASSIGNMENT FILE

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

MS WORD PDF NOTES IN HINDI

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

MS EXCEL PDF NOTES IN ENGLISH

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

MS EXCEL PDF NOTES IN HINDI

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

MS EXCEL PRACTICE ASSIGNMENT FILE

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

INTERNET PDF NOTES IN HINDI

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------

COMPUTER / LAPTOP REPAIRING NOTES IN HINDI

BUY NOW     DOWNLOAD NOW

-----------------------------------------------------------------------------------------------------------------------------