About this app

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

New features

new videos new course new interface

App Permissions

Allows applications to open network sockets.
Allows applications to access information about networks.
Allows using PowerManager WakeLocks to keep processor from sleeping or screen from dimming.
Allows an app to access approximate location.
Allows an app to access precise location.
Allows an application to write to external storage.
Allows read only access to phone state, including the phone number of the device, current cellular network information, the status of any ongoing calls, and a list of any PhoneAccounts registered on the device.
Allows access to the list of accounts in the Accounts Service.
Allows an application to receive the ACTION_BOOT_COMPLETED that is broadcast after the system finishes booting.
Allows an application to read from external storage.