The VBE code window elements


This module provides a brief description of items in the Visual Basic Editor (VBE) interface - Menus and Toolbars, and Windows (see figure 1).


vbe-interface
Fig 1: Visual Basic Editor (VBE) - interface

Menu and Toolbars

  1. Menu bar - with Excel 2003 style menus (mouse over for details): File, Edit, View, Insert, Format, Debug, Run, Tools, Add-Ins, Window, and Help
  2. Tool bars - showing the Standard toolbar (left - figure 2, and right figure 3), and Edit toolbar (figure 4)
  3. standard-toolbar-left
    Fig 2: VBE Standard toolbar - part 1 - left
  4. 1. View Microsoft Excel
  5. 2. Insert UserForm drop-down
  6. 3. Save [Workbook]
  7. 4. Cut
  8. 5. Copy
  9. 6. Paste
  10. 7. Find
  11. 8. Undo Typing
  12. 9. Redo Typing
  13. standard-toolbar-right
    Fig 3: VBE Standard toolbar - part 2 - right
  14. 10. Run Sub/UserForm
  15. 11. Break
  16. 12. Reset
  17. 13. Design Mode
  18. 14. Project Explorer
  19. 15. Properties Window
  20. 17. Toolbox
  21. 18. Microsoft Visual Basic for Applications Help
  22. edit-toolbart
    Fig 4: VBE Edit toolbar -
  23. 21. List Properties/Methods
  24. 22. List Constants
  25. 23. Quick Info
  26. 24. Parameter Info
  27. 25. Complete Word
  28. 26. Indent
  29. 27. Outdent
  30. 28. Toggle Breakpoint
  31. 29. Comment Block
  32. 30. Uncomment Block
  33. 31. Toggle Bookmark
  34. 32. Next Bookmark

Windows

  1. Project Explorer - shows a hierarchical list of Objects (workbook and worksheet code modules), Modules (standard), Forms (code and object), and Class Modules
  2. Properties Window - list of properties for the selected object, either alphabetic or categorized
  3. Code Window - write, edit, insert, or delete code
  4. Immediate Window - run one line code statements (eg. ActiveCell.Value = 123 [ENTER]), repeat individual statement - click in the statement and Press [ENTER], view code output from a module with the Debug.Print statement
  5. Locals Window - monitor values and properties of active elements. Use Break and/or Step mode
  6. Watch Window - monitor the values of selected module elements