Variables and loops in VBA in Excel - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a variable in VBA?

A variable is a named storage that holds data which can change while the program runs. Think of it like a labeled box where you keep information to use later.

beginner

How do you declare a variable in VBA?

Use the Dim statement followed by the variable name and type. For example: Dim count As Integer creates a variable named count that stores whole numbers.

beginner

What is a For loop in VBA used for?

A For loop repeats a block of code a set number of times. It’s like telling Excel to do something over and over, counting from a start number to an end number.

intermediate

Explain the difference between For and Do While loops in VBA.

For loops run a fixed number of times decided before starting. Do While loops keep running as long as a condition is true, which might be unknown before the loop starts.

intermediate

What happens if you forget to increment the loop counter inside a Do While loop?

The loop may run forever because the condition never becomes false. This is called an infinite loop and can freeze your program.

Which statement correctly declares a variable named 'score' as a number in VBA?

A Dim score As Integer

B Var score = 0

C Declare score Number

D Set score = Integer

In VBA, variables are declared using 'Dim' followed by the name and type, like 'Dim score As Integer'.

What does this VBA code do? <br>For i = 1 To 5<br> MsgBox i<br> Next i

A Shows one message box with number 5

B Creates 5 message boxes at once

C Shows message boxes with numbers 1 to 5 one by one

D Does nothing

The 'For' loop runs from 1 to 5, showing a message box with the current number each time.

Which loop type runs while a condition is true?

A For loop

B Do While loop

C Select Case

D If statement

'Do While' loops continue running as long as the condition remains true.

What keyword is used to end a 'For' loop in VBA?

A End For

B Loop

C Exit

D Next

The 'Next' keyword tells VBA to go to the next loop iteration or end the loop if done.

What is the risk of not changing the loop variable inside a 'Do While' loop?

A The loop may run forever (infinite loop)

B The loop will never run

C The loop will run only once

D The loop will skip iterations

If the condition never becomes false, the loop keeps running endlessly, causing an infinite loop.

Describe how to declare and use a variable in VBA with an example.

Think about how you tell Excel to remember a number or text.

Explain the difference between a 'For' loop and a 'Do While' loop in VBA and when you might use each.

One counts a set number of times, the other depends on a condition.