VBA editor basics in Excel - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Identify the VBA Editor Window

Which window in the VBA editor shows the list of all modules, forms, and classes in your workbook?

A Code Window

B Project Explorer

C Properties Window

D Immediate Window

💡 Hint

This window helps you navigate between different VBA components.

The Project Explorer shows all modules, forms, and classes in your VBA project. It helps you find and open code files.

📊 Formula Result

intermediate

Output of a Simple VBA MsgBox

What message box text appears when you run this VBA code?

Sub ShowMessage()
  MsgBox "Hello, Excel!"
End Sub

Excel

Sub ShowMessage()
  MsgBox "Hello, Excel!"
End Sub

A Syntax error in code

B A message box with text: ShowMessage

C No message box appears

D A message box with text: Hello, Excel!

💡 Hint

MsgBox shows a popup with the text inside quotes.

The MsgBox function displays a popup message box with the given text. Here it shows 'Hello, Excel!'.

❓ Function Choice

advanced

Choosing the Correct VBA Function to Get Cell Value

Which VBA code correctly reads the value from cell A1 in the active worksheet?

A Range("A1").Value

B WorksheetFunction.CellValue("A1")

C Cells(1, "A").Text

D ActiveSheet.Cell("A1")

💡 Hint

Use Range with cell address and .Value to get the content.

Range("A1").Value returns the value in cell A1. Other options are invalid or incorrect VBA syntax.

🎯 Scenario

advanced

Debugging VBA Code with Breakpoints

You want to pause your VBA code at a specific line to check variable values. What is the correct way to set a breakpoint in the VBA editor?

A Right-click the code and select 'Stop Execution'

B Insert a MsgBox before the line

C Click the gray margin next to the code line to toggle a red dot

D Add the line 'Pause' in your code

💡 Hint

Breakpoints appear as red dots in the margin.

Clicking the gray margin next to a line sets a breakpoint, shown as a red dot. This pauses code execution at that line.

❓ data_analysis

expert

Understanding Variable Scope in VBA Modules

Given this VBA code in a module:

Dim counter As Integer

Sub Increment()
  counter = counter + 1
  MsgBox counter
End Sub

Sub Reset()
  counter = 0
End Sub

What will be the message box output after running Increment twice, then Reset, then Increment once?

Excel

Dim counter As Integer

Sub Increment()
  counter = counter + 1
  MsgBox counter
End Sub

Sub Reset()
  counter = 0
End Sub

A 1, then 2, then no message, then 1

B 1, then 2, then 1, then 2

C 1, then 2, then 0, then 1

D 1, then 1, then 0, then 1

💡 Hint

Module-level variables keep their value between sub calls unless reset.

The variable counter starts at 0 by default. Each Increment adds 1 and shows the value. Reset sets it to 0. So the sequence is 1, 2, 0 (no message box), then 1.