Free Learn Excel VBA in 3hrs

Features 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