Page 410 - Excel for Scientists and Engineers: Numerical Methods

Appendix 2

Shortcut Keys for VBA

Shortcut keys for running and debugging code
Halt execution ESC
Run F5
Step through code F8
Toggle breakpoint F9
Toggle between Visual Basic Editor and Excel ALT+F 1 1
Step into F8
Step over SHIFT+F8
Run to cursor CTRL+F8
Clear all breakpoints CTRL +SHIFT+F9
Display Quick Watch window SHIFT+F9

Shortcut keys for working in the code window
View Code window F7
Jump to beginning of module CTRL +HOME
Jump to end of module CTRL +END
Undo CTRL +Z
Delete current line CTRL +Y
Indent TAB
Remove tab indent SHIFT+TAB
Print CTRL +P
Paste CTRL +V
Delete DEL or DELETE
Find CTRL +F
Find Next SHIFT+F4

3 87