Excel VBA Programming Book (with real life examples) - Ravi SagarRecent blog postsNavigation |
VBA EditorSo you have recorded your first Macro in Excel VBA but most of the times you want to do something more that cannot be achieved with just recording and for customizing the Macro you need to Modify the VBA Code. VBA Editor is just for that, modifying and writing your own code. What is VBA Editor? VBA Editor is the Window where Code for Excel VBA is written. It is just like any other Text editor like Notepad and Wordpad. Instead of plain English the Code is written in the Language which Excel can understand. VBA Editor is also a Program to create and Edit VBA Macros. You can also call it as IDE (Integrated Development Environment) How to Open VBA Editor Select Tools > Macro > Visual Basic Editor Or simply press ALT + F11, it is the shortcut to open the VBA Editor. Parts of VBA Editor VBA Editor can be customized by the user. Many Windows can be added and removed but It is important to know the following Windows. - Editing window: Displays VBA code for editing and User Forms for design. Create a new Module Steps to create a new Module. 1. Open the Excel Worksheet where you want to create a Macro. Edit existing Module Steps to edit any existing Module. 1. In the Project Explorer Window > Click on the small plus sign in front of VBAProject (Excel Sheet Name). |
Recent comments
21 weeks 3 days ago