S3.wp.wsu.edu



Index of VBA Concepts in Excel(L# = page # from the lecture notes; A# = page # from the Albright book)<F2> (object browser)…L63, L82, A22<F5> (run a sub)…L64, L82<F8> (run a sub one step at a time)…L82<Alt><F11> (enter and exit Visual Basic editor)…L63, A18<Tab> (indent)…L65<Shift><Tab> (reverse indent)…L65Activation Button (for a SUB)…L72And…L104, A125-126Application.CutCopyMode = False (presses <Esc>)…L82Arrow (on the Toolbox)…L113, A235Arrow Keys…L74Breaking a loop…L104, A140Built-In Constants in VBA…L74Cancel Button (on a user form)…L116, L121, A242-243Capitalization…L105Carriage Return…L69, L82Case…L97, A126, A129Case Construction…L94, L97-98, A117, A126-129Case Is...L97Case Else…L97-98, A126-129Cells (range property)…L85CheckBox (on a user form)…L113, L117, A235-236, A241ClearContents (erases contents of the range specified)…L82Code Names…L84, A54-56Colors…L74, L85-86Column (range property)…L85ComboBox (on a user form)…L113, A235-236CommandButton (on a user form)…L113, A235-236Comments…L65Compound Conditions…L104, A125-126Concatenation…L69Condition…L95, A120Condition within a condition (nested If statements)…L96, A122-123Const (defines a constant)…L82Constants (built-in)…L74Control (of the program)…L94-105, L107-109Counting backwards (through a loop)…L105, A135Counting columns (or rows)…L105, A133Declaring Variables…L66, L82, A51Designing (a user form)…L112-117, A234-243Dialog Boxes…L111-133, A230-257Dim...L62, L82, A51Do Loop…L94, L102-104, A117, A138-143Else (for IF statements)…L95-96ElseIf (for IF statements)…L96End If…L95-96, A120End Select…L97-98, A126, A129EntireColumn (range property)…L85EntireRow (range property)…L85Event Handlers…L118-124, L130-133Excel Functions...L75-76Exit Do…L104, A139Exit For…L104, A130, A141Exit Sub…A140Exiting a loop…L104, A130Font (range property)…L85For Loop…L94, L99-100, L104-105, A117, A129-A136For Each Loop…L94, L101, L104-105, A117, A136-138FormatCurrency and FormatNumber (for numbers)…L82Frame (on a user form)…L113, L116, A235-236, A241Functions (Excel in VBA)…L75-76Functions (VBA)…L75-76HorizontalAlignment (range property)…L86Horizontal Alignment…L74Icons (for message boxes)…L74If Construction…L94-96, L104-105, A117, A120-A126Image (on a user form)…L113, A236Initial Setup…L65Input Boxes…L67-69Interacting with the Spreadsheet…L72Interior (range property)…L86Is…L97, A127Iterations (with For loops)…L105Lable (on user form)…L113, L116, A235-236, A240LCase (change a string to all lower case)…L105, A143Left (string function)…L77Len (string function)…L77Line Wrap…L65ListBox (on a user form)…L113, L117, A235-236, A241Loop…L102, A138-139Looping…L94, L99-105Looping through cells in range…L101, A136-138Looping through collections…L101, A136-138Looping through objects…L101, A136-138Looping through sheets…L107, A137lower case (changing a string to all lower case with LCase)…L105, A143Matching string…L105Message Box Icons…L74Message Boxes…L67-68, L73Methods of Ranges…L88-89Mid (string function)…L77Modules…L64MultiPage (on a user form)…L113, A236Name (range property)…L86Name (worksheet property)…L84Nested If statements…L96, A122-123Nested For Loops…L100, A132-134Next (looping)…L99-101, A130Name Property…A55-56NumberFormat (range property)…L86Number Format…L82Object Browser…L63, L82, A22Object Variables…A53Offset…L86, L90-92, L100, L103OK Button (on a user form)…L115, L121, A242-243OptionButton (on a user form)…L113, L117, A235-236, A241Or…L96, L104, A125-126Pointer (on the Toolbox)…L113, A235Program Control…L94-105, L107-109, A117-144Properties of Ranges…L85-87Range…L72, L75-76, L85-92Range Methods…L88-89Range Properties…L85-87RefEdit (on a user form)…L113, A236Referencing Worksheets…L84Replace (string function)…L77Right (string function)…L77Row (range property)…L87Running a SUB…L64, L72, L82ScrollBar (on a user form)…L113, A236Searching for a name in a list…A141-143Searching through a rectangular range…L100, A130-A133Select Case…L97-98, A126, A129SET (an object variable)…A53-54Setup (initial)…L65Sheet Names…L84, A54-56Sorting by header label instead of selecting the whole range…A128SpinButton (on a user form)…L113, L122, A236Spreadsheet interaction with VBA…L72Step…L105, A130, A135String Functions…L77Strings…L69, L77StrReverse (string function)…L77SUB (subroutines)…L64, A49Sub Control…L108-109TabStrip (on a user form)…L113, A236TextBox (on a user form)…L113, L116, A235-236, A241Then (for If statements)…L95-96To…L99, A126, A129ToggleButton (on a user form)…L113, A235-236UCase (change a string to all upper case)…L105, A143upper case (changing a string to all lower case with UCase)…L105, A143User Forms…L111-133, A231-262User-Defined Functions…L78-79Value (range property)…L87Variables…L66, A51VBA Functions…L75-76vBCritical (icon)...L74vbCrLf (carriage return)…L82vBExclamation (icon)...L74vBInformation (icon)...L74vbNewLine (carriage return)…L69, L82vBQuestion (icon)...L74vbTab…L82Visual Basic Editor…L63With Construction…L87, L90-92Worksheet Names…L84, A54-56Wrap a Line…L65Yes-No Box…L68 ................
................

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

Google Online Preview   Download