Tips

Navigating the Code VBA menu

  • Use Alt - keys to minimize switching from keyboard to mouse and back
  • You can move to menu items with underscore by pressing the underscored character / shortcut key
  • In most cases the first character of the menu item is its shortcut key
  • If on the menu only one item has the shortcut key, pressing the key immediately triggers the menu action
  • If on the menu multiple items have the same shortcut key, pressing the key move to the next item with that key. Pressing [Enter] starts the selected action
  • In some cases menus can be very long. In such cases use PgDn to move through
  • A limited set of mnemonics let you move to the most common menu items
N: Name
D: Declare
I: If Then
F: For loop
A: Add Fragment
M: Manage Fragments
R: Reference
T: Tutorial
==for classes==
S: Set
M: Methods
P: Properties
  • If accidentally what you inserted is not what you wanted, use Alt-Backspace to undo the last changes
  • Walk through the Settings and change them to match the way you prefer the builders to work.
  • Train yourself in using Code VBA instead of typing. The more you use it, the more time it will save you.

 

Preferences