VBA basics

In Excel VBA, which object represents the entire Excel application?

Which statement is used to display a message to the user in a pop-up dialog box?

Suppose you have Dim arr(1 To 5) As Long and you assign arr(1)=10. Which element are you modifying?

Which of the following is a valid method of the Workbook object?

To halt code execution and open the VBA debugger, what is the correct statement to insert?

In the Excel Object Model, which item is the direct parent of a Worksheet object?

If you want to repeat instructions until a condition becomes true, which loop form can you use?

Which statement about the Dim keyword is true?

What is the effect of Range("A1").ClearContents?

If you see Range("B10").End(xlUp), which direction does End(xlUp) move the active reference?

Which of the following declares and checks all variables for correct spelling in a module?

You have a Sub procedure that needs to return a value. How can you achieve that?

Which statement about Cells is correct?

In VBA, how do you concatenate two strings s1 and s2?

Which property of the Range object can set or retrieve an array of values for multiple cells at once?

Worksheets("Sheet1").Activate will:

You want to check if the value in cell A2 is blank in your code. Which approach is simplest?

In a For i = 1 To 5 Step 2 loop, which values will i take?

Which of these is not a valid object in the Excel VBA object model?

If you want to exit a Do Loop early, which statement do you use?

When working with a With... End With block referencing Range("A1"), how do you set the font to bold inside that block?

Declaring Private i As Long at the top of a module (outside any Sub/Function) means:

Which function is specifically used to retrieve the number of rows in a dynamic array named myArray?

To declare a long integer variable in VBA, which syntax is correct?

Which is not a valid way to reference a range of cells from A1 to C3?

A user-defined function in VBA must end with:

Which statement about the Static keyword is correct?

To automatically fill the active cell with today’s date, you can use:

Which of these data types can hold fractional numeric values with high precision?

The Me keyword in a UserForm or Class Module refers to:

For Each cell In Range("A1:A10") will:

When you see Application.ScreenUpdating = False, it generally means:

Option Base 1 will do what?

If you want to merge the contents of two cells, B2 and C2, into cell A2 as a string, which line might work best?

In a Function procedure named MyCalc, how do you specify the return value?

Which method can you use to copy a range’s contents from A1:A5 to B1:B5 in VBA?

How can you check if cell E5 contains a formula or a fixed value in older versions of Excel?

Which code snippet loops backwards from 10 down to 1 in a For loop?

In VBA, which operator performs exponentiation (raising to a power)?

If you have Dim rng As Range, how do you release the reference from memory when done?

To pause execution at runtime, you can insert:

If you want to determine the last used row in column A, which method is most efficient?

Given a range named DataRange, how do you correctly resize it to include one additional column to the right?

You need to sum all values in column B where the corresponding value in column A is “Complete”. Which approach is most appropriate?

What is the correct way to declare an object variable that can hold a reference to any type of object in VBA?

How can you prevent a user from interacting with the Excel application while a VBA macro is running?

When working with events, what is the purpose of the ByVal Target As Range argument in a Worksheet_Change event handler?

You have a dynamic array myArray. How do you redimension it to preserve its existing values while changing the size of the last dimension?

What happens if you try to access an array element using an index that is outside the declared bounds?

You are working with the FileSystemObject. Which method is used to create a new text file?

When using the Like operator for pattern matching, what does the # character represent?

How do you declare a constant in VBA?

Which function is suitable for determining if a variable has been initialized?

You aim to read all lines from a text file sequentially. Which object is best suited for this task?

How can you ensure that a variable's value is retained between calls to a procedure?

Which statement accurately describes the Call keyword in VBA?

Suppose you need a collection that provides key-based access to its elements, which data structure is suitable?

What is the primary use of UserForms in Excel VBA?

When should you use Option Explicit in your VBA modules?

Which of the following is the correct way to write a value to a cell using its row and column numbers?

What is the key advantage of using parameterized queries with ADO in VBA?

How does the On Error Resume Next statement affect the execution flow in VBA?

You want to create a custom function in VBA. How do you specify the data type that the function will return?

What is the purpose of the WithEvents keyword when declaring an object variable?

What is the difference between ByRef and ByVal when passing arguments to a procedure?

Given the code Debug.Print TypeName(Range("A1").Value), what will be printed in the Immediate Window if cell A1 contains the text "Hello"?