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)…L62, L81, A22<F5> (run a sub)…L63, L81<F8> (run a sub one step at a time)…L63, L81<Ctrl><F8> (run a sub to the point of the cursor)…L81<F9> (insert a breakpoint to pause execution)…L81<Alt><F11> (enter and exit Visual Basic editor)…L62, A18<Tab> (indent)…L64<Shift><Tab> (reverse indent)…L64Activation Button (for a SUB)…L71And…L103, A125-126Application.CutCopyMode = False (presses <Esc>)…L81Arrow (on the Toolbox)…L114, A235Arrow Keys…L73Breaking a loop…L103, A140Built-In Constants in VBA…L73Cancel Button (on a user form)…L117, L122, A242-243Capitalization…L104Carriage Return (starting a new line in a message box)…L68, L81Case…L96, A126, A129Case Construction…L93, L96-97, A117, A126-129Case Is...L96Case Else…L96-97, A126-129Cells (range property)…L84CheckBox (on a user form)…L114, L118, A235-236, A241Clear (range method)…L87ClearContents (range method)…L81, L87Code Names…L83, A54-56Colors…L73, L84-85Column (range property)…L84ComboBox (on a user form)…L114, A235-236CommandButton (on a user form)…L114, A235-236Comments…L64Compound Conditions…L103, A125-126Concatenation…L68Condition…L94, A120Condition within a condition (nested If statements)…L95, A122-123Const (defines a constant)…L81Constants (built-in)…L73Control (of the program)…L93-104, L107-109Copy (range method)…L87Counting backwards (through a loop)…L104, A135Counting columns (or rows)…L104, A133Declaring Variables…L65, A51Designing (a user form)…L113-118, A234-243Dialog Boxes…L112-132, A230-257Dim...L65, L81, A51Do Loop…L93, L101-104, A117, A138-143Else (for IF statements)…L94-95ElseIf (for IF statements)…L95End (to specify ranges)…L90End If…L94-95, A120End Select…L96-97, A126, A129EntireColumn (range property)…L84EntireRow (range property)…L84Event Handlers…L119-123, L129-132Excel Functions (in VBA)...L74-75Exit Do…L103, A139Exit For…L103, A130, A141Exit Sub…A140Exiting a loop…L103, A130Font (range property)…L84For Loop…L93, L98-99, L103-104, A117, A129-A136For Each Loop…L93, L100, L103-104, A117, A136-138FormatCurrency and FormatNumber (for numbers)…L81Frame (on a user form)…L114, L117, A235-236, A241Functions (Excel in VBA)…L74-75Functions (VBA)…L74-75HorizontalAlignment (range property)…L85Horizontal Alignment (built-in constants)…L73Icons (for message boxes)…L73If Construction…L93-95, A117, A120-A126Image (on a user form)…L114, A236Initial Setup…L64Input Boxes…L66-67, L79-80Interacting with the Spreadsheet…L71Interior (range property)…L85Is…L96, A127Iterations (with For loops)…L104Lable (on user form)…L114, L117, A235-236, A240LCase (change a string to all lower case)…L104, A143Left (string function)…L76Len (string function)…L76Line Wrap…L64ListBox (on a user form)…L114, L118, A235-236, A241Loop…L101-102, A138-139Looping…L93, L98-104Looping through cells in range…L100, A136-138Looping through collections…L100, A136-138Looping through objects…L100, A136-138Looping through sheets…L106, A137Lower case (changing a string to all lower case with LCase)…L104, A143Matching strings…L104Message Box Icons…L73Message Boxes…L66-67, L79Methods of Ranges…L87-88Mid (string function)…L76Modules…L63MultiPage (on a user form)…L114, A236Name (range property)…L85Name (worksheet property)…L83Nested If statements…L95, A122-123Nested For Loops…L99, A132-134Next (looping)…L98-100, A130Name Property…A55-56NumberFormat (range property)…L85Number Format…L81Object Browser…L62Object Variables…A53Offset…L85, L89-90, L99, L102, L104OK Button (on a user form)…L116, L122, A242-243OptionButton (on a user form)…L114, L118, A235-236, A241Or…L95, L103, A125-126Passing (arguments)…L108PasteSpecial (range method)…L87Pointer (on the Toolbox)…L114, A235Program Control…L93-104, L107-109, A117-144Properties of Ranges…L84-86Range…L71, L81, L89-90Range Methods…L87-88Range Properties…L84-86RefEdit (on a user form)…L114, A236Referencing Worksheets…L83Replace (string function)…L76Right (string function)…L76Row (range property)…L86Running a SUB…L63, L71, L81ScrollBar (on a user form)…L114, A236Searching for a name in a list…A141-143Searching through a rectangular range…L99-100, A130-A133Select (range method)…L87Select Case…L96-97, A126, A129SET (an object variable)…A53-54Setup (initial)…L64Sheet Names…L83, A54-56Show…L125Sort (range method)…L88Sorting by header label instead of selecting the whole range…A128SpinButton (on a user form)…L114, L123, A236Spreadsheet interaction with VBA…L71Step…L104, A130, A135StrReverse (string function)…L76String Functions…L76Strings…L68, L76SUB (subroutines)…L63, A49Sub Control…L107-109TabStrip (on a user form)…L114, A236TextBox (on a user form)…L114, L117, A235-236, A241Then (for If statements)…L94-95to…L96, A126, A129ToggleButton (on a user form)…L114, A235-236UCase (change a string to all upper case)…L104, A143Unknown Range Sizes…L90, L103Upper case (changing a string to all lower case with UCase)…L104, A143User Forms…L112-132, A231-262User-Defined Functions…L77-78, L98Value (range property)…L86Variable Range Sizes…L91, L105Variables…L65, A51VBA Functions…L74-76vBCritical (icon)...L73vbCrLf (carriage return)…L81vBExclamation (icon)...L73vBInformation (icon)...L73vbNewLine (carriage return)…L68, L80vBQuestion (icon)...L73vbTab…L81Visual Basic Editor…L62With Construction…L86, L89-90Worksheet Names…L83, A54-56Wrap a Line…L64Yes-No Box…L67 ................
................

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

Google Online Preview   Download