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

2.4

11 valoraciones en total