Free Learn Excel VBA in 3hrs

About: Free Learn Excel VBA in 3hrs

Free Learn Excel VBA in 3hrs
video course
-------------------------------------------------
Chapter-1
- Introducing object-oriented programming



- Examining the Excel object model
-Working in the Visual Basic editor
- Setting VBA project properties
- Creating, exporting, and deleting code modules
- Creating a subroutine or function
- Controlling procedure scope and visibility
- Adding comments to the code
- Running a VBA routine
- Adding code to a recorded macro

Chapter-2
- Introducing Excel VBA data types
- Declaring variables and requiring declaration before use
- Managing variable scope
- Defining static variables and constants
- Creating a calculation using mathematical operators
- Defining arrays
- Defining and using object variables
- Streamlining code references using With...End With statements

Chapter-3
- Repeating a task using a For...Next loop
- Stepping through all items of a collection using a For...Each loop
- Repeating a task with a Do loop
- Performing a task when conditions are met using If...Then
- Selecting which action to take using a Case statement

Chapter-4
- Managing errors using On Error statements
- Stepping through a subroutine or function
- Setting breakpoints in the code
- Verifying output using the Immediate window
- Watching a value in a routine

Chapter-5
- Writing a value to a cell
- Cutting, copying, and pasting cell data
- Finding values in cells
- Referring to cells using the Offset function
- Concatenating text strings
- Returning part of a string
- Managing worksheets with VBA
- Managing workbooks with VBA

Chapter-6
- Turning off screen updating within a macro
- Using worksheet functions in a macro
- Acquiring values using an input box or message box
- Calling a subroutine from another subroutine

Chapter-7
- Running a procedure when you open, close, or save a workbook
- Running a procedure when a cell range changes
- Triggering a procedure using a specific key sequence

----------------------------------------------------------------------------------------------
VBA Excel Guide
Learn MS Excel VBA