Lesson#2 VBA Statements

Question 1

What are the 5 basic elements of VBA language?

Answer 1

Objects, Collections, Properties, Methods and Parameters.

Question 2

What is an Object?

Answer 2

You use an object to refer to something. e.g. A workbook, represented by the workbook object.

Question 3

What are Collections?

Answer 3

When you refer to several alike objects at the same time. e.g. All open workbooks represented by the Workbooks collection.

Question 4

What are properties?

Answer 4

The characteristics or attributes of an object. e.g. The address of a cell (the Range.Address property)

Question 5

What are methods?

Answer 5

They express an action you carry out with , or on, an object. e.g. Copying, Cutting or Pasting (the copy, cut and paste methods)

Question 6

What are parameters?

Answer 6

They allow you to further specify:

• How a method is carried out.
• A property behaves or is modified.

Question 7

How do you connect object with properties or methods?

Answer 7

Using a dot. ‘.’

Question 8

What is the basic structure of a VBA statement?

Answer 8

An object, a dot and a property or method. e.g. Object.Property