07 - Loops and Reports Quiz - Excel VBA Is Fun

What's the correct syntax for a For Next loop?

For X is equal to 3 until 14 'stuff here Next X

Correct Incorrect Correct answer

For X = 3 until 14 'stuff here Next X

Correct Incorrect Correct answer

For X = 3 to 14 'stuff here Next X

Correct Incorrect Correct answer

For X = 3 to 14 'stuff here Next X Repeat Loop

Correct Incorrect Correct answer

An InputBox gathers the user's input from them typing something and hitting OK, but a MsgBox can handle buttons, such as Yes, No, Cancel, or OK. True or False?

True

Correct Incorrect Correct answer

False

Correct Incorrect Correct answer

To automatically do a print preview in your macro, it's easy. Just put .PrintPreview behind the Range or sheet

True

Correct Incorrect Correct answer

False

Correct Incorrect Correct answer

Here's how you'd loop backwards from 100 to 1 going one at a time:

For X = 100 to 1 Backwards 'stuff here Next X

Correct Incorrect Correct answer

For X is 100 to 1 GoBack 'stuff here Next X

Correct Incorrect Correct answer

For X = 100 to 1 Step -1 'stuff here Next X

Correct Incorrect Correct answer

07 - Loops and Reports Quiz

Quiz Summary

Information

Results

Results

Categories

1. Question

2. Question

3. Question

4. Question