Excel Visual Basic Applications for Beginners
This course is an introduction to Excel Visual Basic Applications or VBA. It introduces you to how VBA and you can use the Visual Basic Editor to create procedures (referred to as a macro) with VBA code that accomplishes a task. The macros you will
1
Segment - 01 - Course Overview
Segment - 02 - How to Save Macros
Source File
2
Segment - 03 - Topics Overview
Segment - 04 - Build a Simple Message
Segment - 05 - Build an Advanced Message
Segment - 06 - Empty a Sheet with the MsgBox Function
Segment - 07 - Prompt User for Input
123
3
Segment - 08 - Topics Overview
Segment - 09 - Object Hierarchy
Segment - 10 - Change Multiple Worksheets
Segment - 11 - Add and Count Worksheets
Segment - 12 - Get Path of a Workbook
Segment - 13 - Open and Close Workbooks
Segment - 14 - Loop Through Worksheets and Workbooks
Segment - 15 - Build a Sales Calculator
Segment - 16 - Change Charts
Resources
4
Segment - 17 - Topics Overview
Segment - 18 - Program a Range of a Spreadsheet
Segment - 19 - Use Cells instead of a Range
Segment - 20 - Use a Range Variable
Segment - 21 - Select a Range
Segment - 22 - Access a Row
Segment - 23 - Copy and Paste a Range
Segment - 24 - Clear a Range
Segment - 25 - Count a Range
5
Segment - 26 - Topics Overview
Segment - 27 - Find the current region of a cell
Segment - 28 - Dynamic Range Program
Segment - 29 - Resize a Range
Segment - 30 - Select Entire Rows and Columns
Segment - 31 - Offset Property
Segment - 32 - End Property
123
6
Segment - 33 - Topics Overview
Segment - 34 - Union and Intersect of Ranges
Segment - 35 - Detect Content
Segment - 36 - Build a Range Program
Segment - 37 - Change Text Color
Segment - 38 - Bold a Range
Segment - 39 - Change Cell Color
Segment - 40 - Work with Areas
Segment - 41 - Find Differences in Ranges
123
7
Segment -42 - Topics Overview
Segment - 43 - Integer Data Type
Segment - 44 - String Data Type
Segment - 45 - Double Data Type
Segment - 46 - Boolean Data Type
Segment - 47 - Retain Variable Value
Source File
8
Segment - 48 - Conditionals
Segment - 49 - If then Statement
Segment - 50 - Else Statement
Source File
9
Segment - 51 - Topics Overview
Segment - 52 - Greeting Program Logical Operator and
Segment - 53 - Logical Operator or
Segment - 54 - Logical Operator not
123
10
Segment - 55 - Topics Overview
Segment - 56 - Select Case
Segment - 57 - Build a Commission Calculator Project
Segment - 58 - Find Remainder with Mod
Segment - 59 - Check Number Program
123