Shortcut for VBA

DAY 2

Short cuts VBE

·         Alt+F4  - close VBE

·         Alt+F5   - Run Error Handler

·         Alt+F6   - Swithch between last 2 windows

·         Alt+F7   - Step Error Handler

·         Alt+F11 - return to application

·         Alt+A     - AddIns Menu

·         Alt+D     - Debug Menu

·         Alt+E     - Edit Menu

·         Alt+f      - File Menu

·         Ctrl+F2  - Focus Object menu

·         Ctrl+F4  - close window

·         Ctrl+F8  - run to cursor

·         Ctrl+F10- Activate menu bar

·         Ctrl+A   - Select All

·         Ctrl+E    - Export Module

·         Ctrl+F    - Find

·         Ctrl+G   - Immediate Window

·         Ctrl+H   - Replace

·         Ctrl+I     - Turn On Quick Info

·         Ctrl+J     - List Members

·

·         Ctrl+L    - Show call stack

·         Ctrl+M  - Import File

·

·         Ctrl+N   - New Line

·         Ctrl+P    - Print

·         Ctrl+R  - Project Window

·

·         Ctrl+S    - Save

·         Ctrl+T    - Show Availabe Components

·         Ctrl+V   - Paste

·         Ctrl+downarrow-Next Procedure

·

·         Ctrl+spacebar-Turn on complete word

·         Ctrl+Tab - Cycle

VBE

Abbreviated as VBE, Visual Basic Editor is the tool used to

create, modify and maintain Visual Basic for Applications (VBA)

procedures and modules in Microsoft Office applications. The

Visual Basic Editor is included with most Office programs.

To Display Developer Tab 2007

To display the Developer tab, click on the Microsoft Office

button in the top left of the Excel window and then click on the

Excel Options button. When the Excel Options window appears,

click on the Popular option on the left. Select the option

called "Show Developer tab in the Ribbon". Then click on the OK

button.

To Display Developer Tab 2010

To display the Developer tab, follow these steps: Click the

Microsoft Office Button, and then click Excel Options. Click

Personalize. Click to select the Show Developer tab in the

Ribbon check box.

To Display Developer Tab 2013

follow these two steps:

Choose File→Options or press Alt+FT to open the Excel Options

dialog box. Click the Customize Ribbon tab, select the Developer check box

under Main Tabs in the Customize the Ribbon list box on the

right side of the dialog box, and then click OK.