by Microsoft

Keyboard shortcuts for the Visual Basic Editor

keyboard-shortcuts

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]

Advertisements
 
Author:
We hope, We will become the best, creative and inspiring community for web and graphics. Join Us! Can be part of the growing Team. Just write something Creative and Interesting. Click here to become a member.

Comments

singencunny Aug 19, 2009

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 Aug 25, 2009

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.

I like that you

think. Thank you for share very

Louboutin shoes Jun 16, 2010

This guy is really lucky !

arnerog2000 Oct 30, 2010

The App iPhone and it’s visual tricks
are different from common desktop interfaces because it uses a direct manipulation model of scrolling

Jonathan Jun 16, 2011

I 100% agree with your way of thinking. Everything makes complete sense finally, thanks a lot.

Trackbacks to this post.
Leave a Reply

Copyright © 2020 Freebies, Free Fonts, WordPress Themes, Logos & Tutorials. All Rights Reserved.
Powered by Wordpress.
About Us | Advertise | Write For Us | Contact Us