UserForm basics in Excel - Practice Problems & Coding Challenges

Challenge - 5 Problems

📊 Formula Result

intermediate

What is the output of this VBA code in a UserForm?

Consider a UserForm with a TextBox named TextBox1 and a CommandButton named CommandButton1. The following code runs when the button is clicked:

Private Sub CommandButton1_Click()
    MsgBox "Hello, " & TextBox1.Text
End Sub

What happens when the user types Anna in the TextBox and clicks the button?

Excel

Private Sub CommandButton1_Click()
    MsgBox "Hello, " & TextBox1.Text
End Sub

A A message box appears showing: Hello, Anna

B The TextBox clears and no message appears

C An error message appears because TextBox1.Text is invalid

D Nothing happens when the button is clicked

💡 Hint

Think about how the TextBox's Text property is used in the message box.

The code concatenates the string "Hello, " with the text entered in TextBox1. So if the user types "Anna", the message box will show "Hello, Anna".

❓ Function Choice

intermediate

Which VBA function correctly closes a UserForm?

You want to close a UserForm named MyForm when a button is clicked. Which VBA statement will close the form properly?

A Exit UserForm

B Close MyForm

C Unload Me

D End MyForm

💡 Hint

Remember that Me refers to the current UserForm inside its code.

The Unload Me statement closes the current UserForm properly. Other options are not valid VBA syntax for closing forms.

🎯 Scenario

advanced

How to transfer UserForm input to a worksheet cell?

You have a UserForm with a TextBox named TextBoxName and a CommandButton. When the button is clicked, you want to put the text from the TextBox into cell A1 of Sheet1. Which code snippet inside the button click event will do this correctly?

A Range("A1").Text = TextBoxName.Text

B Cells(1, 1).Value = TextBoxName.Text

C Sheet1.Cells(1, 1) = TextBoxName.Value

D Worksheets("Sheet1").Range("A1").Value = TextBoxName.Text

💡 Hint

Use the full reference to the worksheet and the Text property of the TextBox.

Option D correctly references Sheet1 and assigns the TextBox's Text property to cell A1's Value. Option D tries to assign to Range("A1").Text which is read-only; Option D uses Sheet1.Cells(1, 1) = TextBoxName.Value, which may work if Sheet1 is the sheet's code name; Option D lacks worksheet reference and may cause errors.

❓ data_analysis

advanced

What error occurs with this UserForm code?

Inside a UserForm, you have this code:

Private Sub CommandButton1_Click()
    Dim num As Integer
    num = CInt(TextBoxNumber.Text)
    MsgBox 100 / num
End Sub

If the user leaves TextBoxNumber empty and clicks the button, what happens?

Excel

Private Sub CommandButton1_Click()
    Dim num As Integer
    num = CInt(TextBoxNumber.Text)
    MsgBox 100 / num
End Sub

A Message box shows 100

B Runtime error: Invalid use of Null or empty string in CInt

C Message box shows 0

D No error, message box shows Infinity

💡 Hint

What happens if you convert an empty string to an integer?

Trying to convert an empty string with CInt causes a runtime error because it cannot convert empty text to a number.

🧠 Conceptual

expert

How does the Me keyword behave inside a UserForm?

In VBA UserForm code, what does the keyword Me refer to?

A The current UserForm instance where the code runs

B The Excel workbook containing the UserForm

C The active worksheet in Excel

D The module where the code is written

💡 Hint

Think about object-oriented programming and how Me is used in class modules.

Inside a UserForm's code, Me refers to the UserForm itself, allowing you to access its controls and properties easily.