![]() |
The Visual Basic Editor (VBE) is the development environment in the MS Office applications. Fortunately, there are a number of keyboard shortcuts that you can use to work more efficiently while entering, viewing, and editing code.
Keyboard Shortcouts :
| General | |
| Alt + F11 | This toggles switch displays the VBE from the application window and vice versa. |
| Ctrl + G | Displays Immediate window. |
| Ctrl + F | Opens the Find dialog box. |
| F3 | Find Next. |
| Shift + F3 | Find Previous. |
| Ctrl + H | Opens the Replace dialog box. |
| Ctrl + Z | Cancels the last keyboard stroke or the last mouse operation (when possible.) |
| F5 | Runs the current procedure or continues execution after pausing. |
| Ctrl + Break | Halts a procedure. |
| Shift + F5 | Terminates a procedure and resets all variables to their default values. |
| Shift + F10 | Displays the active window’s shortcut menu. |
| Ctrl + R | Opens the Project Explorer. |
| F4 | Opens the Properties window. |
| F2 | Opens the Object Browser. |
| F1 | Opens VBA Help. |
| F7 | Gives focus to the open module window. |
| Code module | |
| Ctrl + Down Arrow | Select next procedure. |
| Ctrl + Up Arrow | Select previous procedure. |
| Ctrl + Page Down | Shift one screen down. |
| Ctrl + Page Up | Shift one screen up. |
| Ctrl + Shift + F2 | Go to last position. |
| Ctrl + Home | Go to beginning of module. (Also in the Immediate window.) |
| Ctrl + End | Go to end of module. (Also in the Immediate window.) |
| Ctrl + Right Arrow | Move one word to the right. |
| Ctrl + Left Arrow | Move one word to the left. |
| End | Move to the end of the line. |
| Home | Move to the beginning of the line. |
| Ctrl + Y | Delete current line. |
| Ctrl + Delete | Delete to end of word. |
| Ctrl + Shift + F9 | Clear all breakpoints. |
| Project Explorer | |
| F7Shift + Enter | Open the selected file’s module. |
| Home | Select the first file in the list. |
| End | Select the last file in the list. |
| Right arrow | Expands a sublist. |
| Left arrow | Collapses a sublist. |
| Up arrow | Moves up the list one item at a time. |
| Down arrow | Moves down the list one item at a time. |
[via]
| Hello there! If you find this page useful, you might want to subscribe to the RSS feed or by Email for updates on this topic. |
|
Categories: Microsoft
|
singencunny
August 19th, 2009 at 12:56 am
I watch tv onlinealot, lol some of my favorites are youtube. What are places
can I watch tv online.
Is it legal for me to have explained here?, and bank accounts? How to start? Can I move my existing business offshore
Thanks
Intoleheexolo
August 25th, 2009 at 1:08 pm
Hello everybody,
I’m happy to describe at this page an interesting
kind of earning. Do you know that one
may make up to 3% a per day through investments without limitations in without sum limits?
I mean that even if one has US$1.000,00 one can earn the same money in a monthly!
If someone is interested welcome to visit my web site http://www.theinvestblog.com.
Nokia Codes – Nokia Mobile Code – Nokia Secret Code « Technology news, wordpress themes, mobile news, latest mobile news, twitter icons, twitter buttons, seo tips, make money, telecom news, broadband news
October 25th, 2009 at 1:22 pm
[...] Keyboard shortcuts for the Visual Basic Editor [...]