Basic VBA

It is similar to the Excel ribbon where you have tabs and options with each tab.

• Menu bar

• Tool Bar

• Project Explorer

• Module

It gives you quick access to some of the useful options.

• Tool Bar

• Menu Bar

• VBA Ribbon

• Function Bar

Shortcut Key for Project Explorer

• Ctrl + K

• Ctrl + L

• Ctrl + R

• Ctrl + P

This is where the code that is generated with a macro recorder goes.

• Code Window

• Module

• Immediate window

• Properties Window

This is where you’ll write your code or copy paste a code from somewhere else.

• Properties window

• Module

• Immediate Window

• Code window

Properties window short cut key

• F6

• F4

• CTRL + P

• F8

is mostly used when debugging code

• Properties Window

• Immediate window

• Code window

• Module

Contains set of commands the code should execute

• Sub procedure

• Function Procedure

• Reference

• Commands

Wrong code color is

• Black

• Blue

• Red

• Green

an action or a set of actions that you can run as many times as you want. When you create a -------, you are recording your mouse clicks and keystrokes.

• VBA

• match index

• Macro

• Vlook up