exam 3 excel 2258

A user-defined function must be created in _______ in Visual Basic Editor.

A Module

VBA code to move from Cell B1 to Cell D4 using RELATIVE referencing.

ActiveCell.Offset(3,2).Select

VBA code to move from cell B1 to cell D4 using RELATIVE referencing.

ActiveCell.Offset(3,2).Select

Explain what these lines are telling excel to do: Dim Answer As String Answer=MsgBox("Do you want a million dollars?",vbYesNo,"Money")

Defining a variable named Answer in Visual Basic. Setting the variable to store text values. Connect variable to message box that asks "do you want a million dollars" and they click yes or no. it will give msg box name "money". when user clicks response, their response will be stored in the variable storage space called Answer.

The first word used in the line of code to define a variable is:

Dim (define in memory)

Write the appropriate line of code to define a variable named Color to store text values.

Dim Color As String

Write the appropriate line of code to define a variable named Quantity to store whole numbers.

Dim Quantity as Integer

Write the appropriate line of code to define a variable named Revenue to store currency values.

Dim Revenue as Currency

A loop that will allow you to run a set of VBA statements over and over again until a specified condition is met is known as a:

Do...Loop

The last line of code for a user-defined function is:

End Function

What is needed for a spin button?

Linked Cell Max Min

What is needed for a scroll bar?

Linked cell Max Min Small Change Large Change

"ActiveWorkbook.Save", "ActiveWorkbook" is a(n): -property -object -method

Object

The _______________ window in the Visual Basic Editor is where you access the modules containing public macros you have created.

Project explorer window

VBA code to move from cell B3 to cell D1 using ABSOLUTE referencing.

Range("D1").Select

What button do you click on to record a new macro?

Record Macro

Explain what this line of code in a macro is telling Excel to do: Range("K24").Select

Select cell K24 using absolute referencing.

The first word in a line of public macro is

Sub

What tab do we use in Excel to work with macros?

developer

A macro that will run every time the file is opened is called a ____________ macro.

private macro