Values of variables and properties of objects can be set or queried during the execution of a procedure using the Immediate Window. To call a procedure simply type the procedure name in the Immediate Window, pass arguments if there are any, and press Enter. Using Debug.Print will output text to the Immediate Window. To access the Immediate Window use the Ctrl + G keyboard shortcut or navigate to View → Immediate Window. The Immediate Window is used to print data from a program, call procedures, set values and properties, call methods on objects, and query the result of an expression. To access the Locals Window navigate to View → Locals Window. The Locals Window is used to view the states of variables during the execution of a program. To access the Watch Window navigate to View → Watch Window.
Alternatively, right-click the Watch Window, select Add Watch, and type the expression. To add a watch, highlight an expression, right-click the expression, and select Add Watch. The Watch Window is used to view how expressions evaluate during a program's execution and to pause execution when certain conditions are reached. Select items within a VBA project to show the properties for that item. To open the properties window use the View menu on the toolbar in the Visual Basic Editor and select Properties Window or press F4. The Properties Window allows the user to set the properties of a VBA project or items within a VBA project. When General is selected the drop-down will contain all procedures declared in the module. The Procedure Box is used to select the procedures available to the codeable object selected by the Object box. General is the default selection and denotes that no specific object is selected.
VISUAL BASIC EDITOR CODE
The Object Box is used to select a codeable object associated with the current code module.
To open the code window for a module, double-click the code module or right-click the code module and select View Code in the Project Explorer. Every code module has its own dedicated code window that is specifically for that module.
VISUAL BASIC EDITOR WINDOWS
Code WindowsĬode Windows are where code is written in VBA. The code modules for application-specific objects like Worksheets and Workbooks are added automatically to the VBA project when these objects are created. Standard modules, Class modules, and UserForms can be inserted or imported by right-clicking in the Project Explorer within a VBA project. UserForm modules and modules associated with application-specific objects are special types of class modules that are attached to an object. There are Standard modules, Class modules, UserForm modules, and modules associated with application-specific objects like Excel Worksheets. Double-click or right-click on objects to access their code modules or access their properties. The Project Explorer is used to access and navigate VBA projects insert, import, export, and remove code modules and access the properties of objects. The Project Explorer shows open VBA projects within the application and the objects associated with the projects. To add the Developer Tab to the ribbon check the Developer checkbox in File → Options → Customize Ribbon.
In most Office applications the Developer Tab can be added to the ribbon and used to access the Visual Basic Editor and other developer features. To access the Visual Basic Editor in Microsoft Office applications use the Alt + F11 keyboard shortcut. The Visual Basic Editor is embedded into applications that support VBA and does not need to be separately downloaded or installed. The Visual Basic Editor provides a place to write, run, debug, and store VBA code. The Visual Basic Editor (VBE) is the built-in Integrated Development Environment (IDE) for coding in VBA.
0 kommentar(er)
