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
For X = 3 until 14 'stuff here Next X
For X = 3 to 14 'stuff here Next X
For X = 3 to 14 'stuff here Next X Repeat Loop

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
False

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

True
False

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
For X is 100 to 1 GoBack 'stuff here Next X
For X = 100 to 1 Step -1 'stuff here Next X

07 – Loops and Reports Quiz

07 – Loops and Reports Quiz

Quiz Summary

Information

Results

Results

Categories

1. Question

2. Question

3. Question

4. Question