Online Computer Course Join Now
Software Engineering Course | Duration: 1 Year | Fees: 1500/- Monthly | Learn 25+ Language | Call / WhatsApp: +91 9650597419 (Vinay Sir) | Address: Sec - 36, Narsinghpur, Gurugram, Haryana
All Computer Notes | Practice Assignment | Hindi & English Medium Computer PDF Notes | Computer eBooks | Call / WhatsApp: +91 9650597419 (Vinay Sir) Grow Your Coaching Business 10x with your own coaching app | अपने नाम से Teaching App बनवायें | Call / WhatsApp: +91 9650597419 (Vinay Sir)
1. CCC PDF Notes Buy Now
2. Basic Computer PDF Notes Buy Now
3. DCA PDF Notes Buy Now
4. ADCA PDF Notes Buy Now
5. PGDCA PDF Notes Buy Now
6. MS Office PDF Notes Buy Now
7. MS Word PDF Notes Buy Now
8. MS Excel PDF Notes Buy Now
9. Adv. Excel PDF Notes Buy Now
10. MS PowerPoint PDF Notes Buy Now
11. Internet PDF Notes Buy Now
12. Tally Prime PDF Notes Buy Now
13. HTML PDF Notes Buy Now
14. CSS PDF Notes Buy Now
15. Java Script PDF Notes Buy Now
16. C language PDF Notes Buy Now
17. C++ PDF Notes Buy Now
18. J Query PDF Notes Buy Now
19. WordPress PDF Notes Buy Now
20. PHP PDF Notes Buy Now
21. VBA Macro PDF Notes Buy Now
22. Python PDF Notes Buy Now
23. Android PDF Notes Buy Now
24. Digital Marketing PDF Notes Buy Now
25. Computer Repair PDF Notes Buy Now

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)

Post a Comment

0 Comments

All Computer Notes

Basic Computer Notes
1.Basic Computer Notes in English
2.Basic Computer Notes in Hindi
3.Computer Related Full Form
4.Computer Shortcut Keys
5.Keyboard Symbols Name
MS Word Notes in Hindi
1.MS Word Practical Notes
2.Chapter1: Introduction to MS Word
3.Chapter 2: Some Basic Point of MS Word
4.Chapter3 : MS Word - File Menu
5.Chapter 4: MS Word - Home Menu
6.Chapter 5: MS Word - Insert Menu
6.Chapter 5: MS Word - Insert Menu
7.Chapter 6: MS Word - Page Layout Menu
8.Chapter 7: MS Word - References Menu
9.Chapter 8: MS Word - Mailing Menu
10.Chapter 9: MS Word - Review Menu
11.Chapter 10: MS Word - View Menu
MS Word Notes in English
1.Chapter1: MS Word Home Menu
2.Chapter2: MS Word Insert Menu
3.Chapter3: MS Word Page Layout Menu
4.Chapter4: MS Word References Menu
5.Chapter5: MS Word Mailings Menu
6.Chapter6: MS Word Review Menu
7.Chapter7: MS Word View Menu
MS Excel Notes in Hindi
1.Chapter1: Introduction to MS Excel
2.Chapter2: MS Excel Home Menu
3.Chapter3: MS Excel Insert Menu
4.Chapter4: MS Excel Page Layout Menu
5.Chapter5: MS Excel Data Menu
6.Chapter6: MS Excel Review Menu
7.Chapter7: MS Excel View Menu
MS Excel Notes in English
1.Chapter1: Introduction to MS Excel
2.Chapter2: MS Excel Home Menu
3.Chapter3: MS Excel Insert Menu
4.Chapter4: MS Excel Page Layout Menu
5.Chapter5: MS Excel Data Menu
6.Chapter6: MS Excel Review Menu
7.Chapter7: MS Excel View Menu
MS PowerPoint Notes in English
1.Chapter1: Introduction to MS MS PowerPoint
2.Chapter2: MS PowerPoint Home Menu
3.Chapter3: MS PowerPoint Insert Menu
4.Chapter4: MS PowerPoint Design Menu
5.Chapter5: MS PowerPoint Transitions Menu
6.Chapter6: MS PowerPoint Animations Menu
7.Chapter7: MS PowerPoint Slide Show Menu
8.Chapter8: MS PowerPoint Review Menu
9.Chapter9: MS PowerPoint View Menu
MS PowerPoint Notes in Hindi
1.Chapter1: Introduction to MS PowerPoint
2.Chapter2: MS PowerPoint Home Menu
3.Chapter3: MS PowerPoint Insert Menu
4.Chapter4: MS PowerPoint Design Menu
5.Chapter5: MS PowerPoint Transitions Menu
6.Chapter6: MS PowerPoint Animations Menu
7.Chapter7: MS PowerPoint Slide Show Menu
8.Chapter8: MS PowerPoint Review Menu
9.Chapter9: MS PowerPoint View Menu
MS Excel Formula Notes
1.How to Add in Excel
2.How to Subtract in Excel
3.How to Multiply in Excel
4.How to Divide in Excel
5.MAX Formula in Excel
6.MIN Formula in Excel
7.ROMAN Formula in Excel
8.SQRT Formula in Excel
9.POWER Formula in Excel
10.LCM Formula in Excel
11.GCD Formula in Excel
12.FACT Formula in Excel
13.LOWER Formula in Excel
14.UPPER Formula in Excel
15.PROPER Formula in Excel
16.LEFT Formula in Excel
17.RIGHT Formula in Excel
HTML Notes
Chapter 1 : Introduction to HTML
Chapter 2 : HTML Versions
Chapter 3 : HTML DOCTYPE Declaration
Chapter 4 : HTML Attributes
Chapter 5 : HTML Heading Tag
Chapter 6 : HTML Text Formatting Tag
Chapter 7 : HTML Anchor Tag
Chapter 8 : HTML Image Tag
Chapter 9 : HTML List Tag
Chapter 10 : HTML Table Tag
Chapter 11 : HTML Marquee Tag
Chapter 12 : HTML Preformatted & Horizontal Tag
Chapter 13 : HTML Image Tag
Chapter 14 : HTML Anchor Tag
Chapter 15 : HTML Audio Tag
Chapter 16 : HTML Video Tag
Chapter 17 : HTML Iframe Tag
Chapter 18 : HTML Form Tag
Chapter 19 : HTML Website Layout
Online Computer Course Join Now
Computer PDF Notes | E-books | Practice Assignments | Project File | Call / WhatsApp: +91 9650597419 (Vinay Sir)
1. CCC PDF Notes Buy Now
2. Basic Computer PDF Notes Buy Now
3. DCA PDF Notes Buy Now
4. ADCA PDF Notes Buy Now
5. PGDCA PDF Notes Buy Now
6. MS Office PDF Notes Buy Now
7. MS Word PDF Notes Buy Now
8. MS Excel PDF Notes Buy Now
9. Adv. Excel PDF Notes Buy Now
10. MS PowerPoint PDF Notes Buy Now
11. Internet PDF Notes Buy Now
12. Tally Prime PDF Notes Buy Now
13. HTML PDF Notes Buy Now
14. CSS PDF Notes Buy Now
15. Java Script PDF Notes Buy Now
16. C language PDF Notes Buy Now
17. C++ PDF Notes Buy Now
18. J Query PDF Notes Buy Now
19. WordPress PDF Notes Buy Now
20. PHP PDF Notes Buy Now
21. VBA Macro PDF Notes Buy Now
22. Python PDF Notes Buy Now
23. Android PDF Notes Buy Now
24. Digital Marketing PDF Notes Buy Now
25. Computer Repair PDF Notes Buy Now