WorksheetsBasic VBA
Total questions: 10
Worksheet time: 3mins
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
