Lesson#4 Properties, Methods and Parameters

Question 1

What are properties?

Answer 1

The characteristics or attributes that describe an object.

i.e. The Looks and Behaviours

Question 2

What are methods?

Answer 2

The actions you carry out with, or on, an object.

Question 3

What 2 things can you do when working with properties?

Answer 3

1. Specify (write) the properties value.

2. Read the properties current value.

Question 4

What 2 things can you do when working with methods?

Answer 4

1. Carry out the action method.

2. Create a new object or return a value.

Question 5

What can you do with parameters or values?

Answer 5

Write the new the value of a property or further specify the behaviour of a property/method.

Question 6

What happens if you omit an optional parameter?

Answer 6

VBA uses it’s default value.

Question 7

What is the structure of a VBA statement that works with method parameters?

Answer 7

Object.Method ParameterList

Question 8

How do you separate a parameter name from it’s value?

Answer 8

:=

Question 9

How do you structure a VBA statement when you are looking to use a method to create a new object or value?

Answer 9

Wrap the parameter list within parentheses instead of using a space.

Question 10

What is the structure of a VBA statement that works with property parameters?

Answer 10

Object.Property(ParameterList)

Question 11

What is the structure of a VBA statement that specifies a new property value?

Answer 11

Object.Property = NewPropertyValue

Question 12

What are the 2 main rules to consider when specifying a new property value?

Answer 12

1. You usually specify a single value.

2. You use the assignment operator. (=)

Question 13

How do you separate Parameters in a list?

Answer 13

Comma and a space.