Flowchart/VBA_HW

Question 1

What is an object? Method? Property?

Answer 1

•Object-workbook, worksheets, ranges (noun)
•Method-predefined action for object
•Property-facts or characteristics about an object

Question 2

What is an example of an object, child object, and method?

Answer 2

Sheets(“Sheet1”).Range(“A1:A5”).Copy

Range is the object child of Sheets. The method is .Copy

Question 3

What are some of the most common methods to use on Range Objects?

Answer 3

ClearContents, ClearFormats, Cut, Copy, Delete, Replace, Select

Question 4

Are all property references Boolean = (True/False)?

Answer 4

…?

Question 5

What are some of the most common properties to use on Range Objects?

Answer 5

Columns, Rows, Width, Offset, Value, Vertical Alignment.

Question 6

What is a conditional structure?

Answer 6

A conditional structure causes the code to do different things depending on the situation.
Common types:
•If-then
•If-then-else
•Nested Ifs
•Select Case
•If…Else If

Question 7

What’s the main difference between a Function and a Sub?

Answer 7

A function must always return a value. You assign this value to the function’s name within its code. A Sub does not return a value.

Also, Functions can be used directly in cells while Subs cannot.