Washington State University



MgtOp 470Index 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)…L62, 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)…L63Activation Button (for a SUB)…L70And…L102, A125-126Application.CutCopyMode = False (presses <Esc>)…L80Arrow (on the Toolbox)…L113, A235Arrow Keys…L72Breaking a loop…L102, A140Built-In Constants in VBA…L72Cancel Button (on a user form)…L116, L121, A242-243Capitalization…L103Carriage Return (starting a new line in a message box)…L67, L80Case…L95, A126, A129Case Construction…L92, L95-96, A117, A126-129Case Is...L95Case Else…L95-96, A126-129Cells (range property)…L83CheckBox (on a user form)…L113, L117, A235-236, A241Clear (range method)…L86ClearContents (range method)…L80, L86Code Names…L82, A54-56Colors…L72, L83-84Column (range property)…L83ComboBox (on a user form)…L113, A235-236CommandButton (on a user form)…L113, A235-236Comments…L63Compound Conditions…L102, A125-126Concatenation…L67Condition…L93, A120Condition within a condition (nested If statements)…L94, A122-123Const (defines a constant)…L80Constants (built-in)…L72Control (of the program)…L92-103, L106-108Copy (range method)…L86Counting backwards (through a loop)…L103, A135Counting columns (or rows)…L103, A133Declaring Variables…L64, A51Designing (a user form)…L112-117, A234-243Dialog Boxes…L111-131, A230-257Dim...L64, L80, A51Do Loop…L92, L100-103, A117, A138-143Else (for IF statements)…L93-94ElseIf (for IF statements)…L94End (to specify ranges)…L89End If…L93-94, A120End Select…L95-96, A126, A129EntireColumn (range property)…L83EntireRow (range property)…L83Event Handlers…L118-122, L128-131Excel Functions (in VBA)...L73-74Exit Do…L102, A139Exit For…L102, A130, A141Exit Sub…A140Exiting a loop…L102, A130Font (range property)…L83For Loop…L92, L97-98, L102-103, A117, A129-A136For Each Loop…L92, L99, L102-103, A117, A136-138FormatCurrency and FormatNumber (for numbers)…L80Frame (on a user form)…L113, L116, A235-236, A241Functions (Excel in VBA)…L73-74Functions (VBA)…L73-74HorizontalAlignment (range property)…L84Horizontal Alignment (built-in constants)…L72Icons (for message boxes)…L72If Construction…L92-94, A117, A120-A126Image (on a user form)…L113, A236Initial Setup…L63Input Boxes…L65-66, L78-79Interacting with the Spreadsheet…L70Interior (range property)…L84Is…L95, A127Iterations (with For loops)…L103Lable (on user form)…L113, L116, A235-236, A240LCase (change a string to all lower case)…L103, A143Left (string function)…L75Len (string function)…L75Line Wrap…L63ListBox (on a user form)…L113, L117, A235-236, A241Loop…L100-101, A138-139Looping…L92, L97-103Looping through cells in range…L99, A136-138Looping through collections…L99, A136-138Looping through objects…L99, A136-138Looping through sheets…L105, A137Lower case (changing a string to all lower case with LCase)…L103, A143Matching strings…L103Message Box Icons…L72Message Boxes…L65-66, L78Methods of Ranges…L86-87Mid (string function)…L75Modules…L62MultiPage (on a user form)…L113, A236Name (range property)…L84Name (worksheet property)…L82Nested If statements…L94, A122-123Nested For Loops…L98, A132-134Next (looping)…L97-99, A130Name Property…A55-56NumberFormat (range property)…L84Number Format…L80Object Browser…L61Object Variables…A53Offset…L84, L88-89, L98, L101, L103OK Button (on a user form)…L115, L121, A242-243OptionButton (on a user form)…L113, L117, A235-236, A241Or…L94, L102, A125-126Passing (arguments)…L107PasteSpecial (range method)…L86Pointer (on the Toolbox)…L113, A235Program Control…L92-103, L106-108, A117-144Properties of Ranges…L83-85Range…L70, L80, L88-89Range Methods…L86-87Range Properties…L83-85RefEdit (on a user form)…L113, A236Referencing Worksheets…L82Replace (string function)…L75Right (string function)…L75Row (range property)…L85Running a SUB…L62, L70, L80ScrollBar (on a user form)…L113, A236Searching for a name in a list…A141-143Searching through a rectangular range…L98-99, A130-A133Select (range method)…L86Select Case…L95-96, A126, A129SET (an object variable)…A53-54Setup (initial)…L63Sheet Names…L82, A54-56Sort (range method)…L87Sorting by header label instead of selecting the whole range…A128SpinButton (on a user form)…L113, A236Spreadsheet interaction with VBA…L70Step…L103, A130, A135StrReverse (string function)…L75String Functions…L75Strings…L67, L75SUB (subroutines)…L62, A49Sub Control…L106-108TabStrip (on a user form)…L113, A236TextBox (on a user form)…L113, L116, A235-236, A241Then (for If statements)…L93-94to…L95, A126, A129ToggleButton (on a user form)…L113, A235-236UCase (change a string to all upper case)…L103, A143Unknown Range Sizes…L89, L103Upper case (changing a string to all lower case with UCase)…L103, A143User Forms…L111-131, A231-262User-Defined Functions…L76-77, L97Value (range property)…L85Variable Range Sizes…L89, L103Variables…L64, A51VBA Functions…L73-75vBCritical (icon)...L72vbCrLf (carriage return)…L80vBExclamation (icon)...L72vBInformation (icon)...L72vbNewLine (carriage return)…L67, L80vBQuestion (icon)...L72vbTab…L80Visual Basic Editor…L61With Construction…L85, L88-89Worksheet Names…L82, A54-56Wrap a Line…L63Yes-No Box…L66 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download