Lesson#11 Control Code Execution and Conditional Execution of Statements

Question 1

What is the GoTo statement?

Answer 1

It allows your code to go to a specific statement.

Question 2

What is the basic statement structure for a GoTo Statement?

Answer 2

GoTo Label

Question 3

How do you distinguish between numeric and text tables in a procedure?

Answer 3

Text labels are followed by a :.

Question 4

What two rules must labels follow in VBA code?

Answer 4

Begin at first character of line of code and cannot be indented.

Question 5

How does the If…..Then statement work?

Answer 5

Executes a set of statements if a condition returns True.

Question 6

What is the structure for a If….Then statement?

Answer 6

If Condition Then
Statements ToExecute
End If

Question 7

How does the If…..Then…..ElseIf…..Else statement work?

Answer 7

Carries out several conditions and executes depending on condition that returns True.

Question 8

What does the Else statement do in a If……Then…..ElseIf……Else statement do?

Answer 8

Executes if none of the above conditions are met.

Question 9

How does a Select Case statement work?

Answer 9

Uses a test expression to decide which set of statements to execute.

Question 10

What is the structure for a Select Case statement?

Answer 10

Select Case TestExpression
    Case Expression#
          StatementsCase1
     Case Else
           ElseStatements
End Select

Question 11

What are the 3 steps executed in a Select Case statement?
Select Case TestExpression
    Case Expression#
          StatementsCase1
     Case Else
           ElseStatements
End Select

Answer 11

1. VBA matches TestExpression to each expression within the expression list.
2. Once VBA finds a matching case, it executes all the corresponding statements.
3. If TestExpression does not match a case, VBA executes Else statement.

Question 12

How do you specify a group of several individual conditions or situations under a single case?

Answer 12

Using (,), the To or the Is keyword.