MgtOp 470

Index of VBA Concepts in Excel

(L# = page # from the lecture notes; A# = page # from the Albright book)

<F2> (object browser)…L61, L80, A22

<F5> (run a sub)…L62, L80

<F8> (run a sub one step at a time)…L80

<Ctrl<F8> (run a sub to the point of the cursor)…L80

<F9> (insert a breakpoint to pause execution)…L80

<Alt<F11> (enter and exit Visual Basic editor)…L61, A18

Tab> (indent)…L63

Shift<Tab> (reverse indent)…L63

Activation Button (for a SUB)…L70

And…L102, A125-126

Application.CutCopyMode = False (presses <Esc>)…L80

Arrow (on the Toolbox)…L113, A235

Arrow Keys…L72

Breaking a loop…L102, A140

Built-In Constants in VBA…L72

Cancel Button (on a user form)…L116, L121, A242-243

Capitalization…L103

Carriage Return…L67, L80

Case…L95, A126, A129

Case Construction…L92, L95-96, A117, A126-129

Case Is...L95

Case Else…L95-96, A126-129

Cells (range property)…L83

CheckBox (on a user form)…L113, L117, A235-236, A241

ClearContents (erases contents of the range specified)…L80

Code Names…L82, A54-56

Colors…L72, L83-84

Column (range property)…L83

ComboBox (on a user form)…L113, A235-236

CommandButton (on a user form)…L113, A235-236

Comments…L63

Compound Conditions…L102, A125-126

Concatenation…L67

Condition…L93, A120

Condition within a condition (nested If statements)…L94, A122-123

Const (defines a constant)…L80

Constants (built-in)…L72

Control (of the program)…L92-103, L106-108

Counting backwards (through a loop)…L103, A135

Counting columns (or rows)…L103, A133

Declaring Variables…L64, L67, A51

Designing (a user form)…L112-117, A234-243

Dialog Boxes…L111-131, A230-257

Dim...L64, L80, A51

Do Loop…L92, L100-103, A117, A138-143

Else (for IF statements)…L93-94

ElseIf (for IF statements)…L94

End If…L93-94, A120

End Select…L95-96, A126, A129

EntireColumn (range property)…L83

EntireRow (range property)…L83

Event Handlers…L118-122, L128-131

Excel Functions...L73-74

Exit Do…L102, A139

Exit For…L102, A130, A141

Exit Sub…A140

Exiting a loop…L102, A130

Font (range property)…L83

For Loop…L92, L97-98, L102-103, A117, A129-A136

For Each Loop…L92, L99, L102-103, A117, A136-138

FormatCurrency and FormatNumber (for numbers)…L80

Frame (on a user form)…L113, L116, A235-236, A241

Functions (Excel in VBA)…L73-74

Functions (VBA)…L73-74

HorizontalAlignment (range property)…L84

Horizontal Alignment…L72

Icons (for message boxes)…L72

If Construction…L92-94, A117, A120-A126

Image (on a user form)…L113, A236

Initial Setup…L63

Input Boxes…L65-66, L78-79

Interacting with the Spreadsheet…L70

Interior (range property)…L84

Is…L95, A127

Iterations (with For loops)…L103

Lable (on user form)…L113, L116, A235-236, A240

LCase (change a string to all lower case)…L103, A143

Left (string function)…L75

Len (string function)…L75

Line Wrap…L63

ListBox (on a user form)…L113, L117, A235-236, A241

Loop…L100, A138-139

Looping…L92, L97-103

Looping through cells in range…L99, A136-138

Looping through collections…L99, A136-138

Looping through objects…L99, A136-138

Looping through sheets…L105, A137

Lower case (changing a string to all lower case with LCase)…L103, A143

Matching string…L103

Message Box Icons…L72

Message Boxes…L65-66, L78

Methods of Ranges…L86-87

Mid (string function)…L75

Modules…L62

MultiPage (on a user form)…L113, A236

Name (range property)…L84

Name (worksheet property)…L82

Nested If statements…L94, A122-123

Nested For Loops…L98, A132-134

Next (looping)…L97-99, A130

Name Property…A55-56

NumberFormat (range property)…L84

Number Format…L80

Object Browser…L61

Object Variables…A53

Offset…L84, L88, L98, L101, L103

OK Button (on a user form)…L115, L121, A242-243

OptionButton (on a user form)…L113, L117, A235-236, A241

Or…L94, L102, A125-126

Passing (arguments)…L107

Pointer (on the Toolbox)…L113, A235

Program Control…L92-103, L106-109, A117-144

Properties of Ranges…L83-85

Range…L70, L80, L88-89

Range Methods…L86-87

Range Properties…L83-85

RefEdit (on a user form)…L113, A236

Referencing Worksheets…L82

Right (string function)…L75

Row (range property)…L85

Running a SUB…L62, L70, L80

ScrollBar (on a user form)…L113, A236

Searching for a name in a list…A141-143

Searching through a rectangular range…L98, A130-A133

Select Case…L95-96, A126, A129

SET (an object variable)…A53-54

Setup (initial)…L63

Sheet Names…L82, A54-56

Sorting by header label instead of selecting the whole range…A128

SpinButton (on a user form)…L113, A236

Spreadsheet interaction with VBA…L70

Step…L103, A130, A135

String Functions…L75

Strings…L67, L75

SUB (subroutines)…L62, A49

Sub Control…L106-108

TabStrip (on a user form)…L113, A236

TextBox (on a user form)…L113, L116, A235-236, A241

Then (for If statements)…L93-94

to…L95, A126, A129

ToggleButton (on a user form)…L113, A235-236

UCase (change a string to all upper case)…L103, A143

Upper case (changing a string to all lower case with UCase)…L103, A143

User Forms…L111-131, A231-262

User-Defined Functions…L76-77

Value (range property)…L85

Variables…L64, A51

VBA Functions…L73-74

vBCritical (icon)...L72

vbCrLf (carriage return)…L80

vBExclamation (icon)...L72

vBInformation (icon)...L72

vbNewLine (carriage return)…L67, L80

vBQuestion (icon)...L72

vbTab…L80

Visual Basic Editor…L61

With Construction…L85, L88

Worksheet Names…L82, A54-56

Wrap a Line…L63

Yes-No Box…L66