To break out of infinite loop that's running, use Ctrl + Break
---


To bring up Intellisense box, use Ctrl + spacebar
---


To bring up Help on a keyword, highlight the keyword and press F1.
---


To make all the formulas in a spreadsheet visible, use Ctrl-`. You can also choose the menus  Tools --> Options --> View Tab --> select Formulas.
---


To make context-sensitive help appear for built-in functions, choose Auto Quick Info, from the VBE Editor, choose Tools, Options.
---


To always show full menus (not adaptive menus), choose Tools --> Customize --> Always Show Full Menus.
---


To make the Macro Recorder use relative rather than absolute references, click the Relative References box on the Stop Recording toolbar.
---


You can display a list of the available intrinsic constants by typing "intrinsic constants" in the Help box in the Visual Basic Editor.
---


To run a Sub, can use the Application.Run method. Useful if you want your code to call different Sub's depending on different conditions.
---


Can specify a Sub in another module:
   Call myModuleName.mySubName()
Can specify a Sub in another open workbook:
   Application.Run "'myWorkbook.xls'!mySubName"
---


Can force all procedures in a module to be private to a module with Option Private Module. Can still link to procedures through Toolbar or Menu Item.
---


Subs are Public by default. Using Static keyword in Sub declaration will make all variables Static in Sub. Can reset all static variables by choosing Run --> Reset in Visual Basic Editor.
---


Can move or copy multiple sheets at a time, by Array function. For example:
   Sheets(Array("Summary", "PivotTable")).Move Before:=Sheets(1)
---


Can select more than one worksheet at a time, using the Array function: For example:
   Worksheets(Array("Sheet1", "Sheet2")).Select