1.0 Introduction

Question 1

What is variable?

Answer 1

a symbolic name that can take on different values
▪ a memory location

Question 2

what is constant

Answer 2

a value

Question 3

when you open Excel to write a VBA code for the first time, what is the first thing you do?

Answer 3

save the file as “.xlsm” file type or else macros will be lost
▪ m stands for macro-enabled

Question 4

what are macros?

Answer 4

short programs that carry out usually non-mathematical operations
-eg. formatting and filling cells with values
* often executed with short-cut keystrokes to achieve desired result easily and quickly
* example: computer codes behind many of toolbar tools on Word and Excel are macros
* generally people use word “macro” to mean any computer program

Question 5

what are subs?

Answer 5

most general purpose
* offers most flexibility
* can be written with or without any parameters (except for main Sub program)
* can use graphical user interface (GUI) to get info from user
* can contain sequence of mathematical operations
- eg. decisions and loops

Question 6

functions

Answer 6

short programs that can carry out mathematical operations
* but can also be used for non-mathematical operations
* except for a few, functions require parameters
* all functions return a result
* since functions always return a result, they can be used in formula on the worksheet, in
macros, and in subs

Question 7

what can you do with vba

Answer 7

with VBA, create ONE workbook that can be used repeatedly for different values of inputs

Question 8

what is VBA

Answer 8

Visual Basic for Applications. A programming language that expands and enhances the problem. Solving capabilities of Excel.

Question 9

How to get to VBA in Excel?

Answer 9

In Excel > File > Options > Customize Ribbon > Select Devloper

Question 10

Which windows are open when you open VBA and what are they?

Answer 10

Project/project explorer
-contains the components of your project
Properties window
-contains the properties of the components of your project

Question 11

what happens when you insert a new module =>

Answer 11

a corresponding code window appear with project explorer and properties

Question 12

where can you rename your module?

Answer 12

Properties

Question 13

Decision

Answer 13

conditional execution of statements

Question 14

Loop

Answer 14

performs the same calculation over and over again over a range of values of a certain parameter

Question 15

what is computer program

Answer 15

a set of instructions to the computer
-instructions must be given in sequence without ambiguity
-fast but has no intelligence
-needs input information to provide output