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
-----------------------------------------------------------------------------------------------------------------------------
0 Comments