Completed
Excel VBA Topic 2.7 - Making Better Use of Space
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Introduction to Excel VBA Programming
Automatically move to the next video in the Classroom when playback concludes
- 1 Excel VBA - Introduction to Topic 1
- 2 Excel VBA Topic 1.1 - Getting Started in Excel (2007)
- 3 Excel VBA Topic 1.2 - Order of Operations
- 4 Excel VBA Topic 1.3 - Defining Cell Names
- 5 Excel VBA Topic 1.4 - Built-in Functions in Excel
- 6 Excel VBA Topic 1.5 - Relative vs Absolute References in Worksheets
- 7 Excel VBA Topic 1.6 - Plotting in Excel 2007
- 8 Excel VBA - Introduction to Topic 2
- 9 Excel VBA Topic 2.1 - Accessing the VBA Environment
- 10 Excel VBA Topic 2.2 - Creating Your First VBA Macro
- 11 Excel VBA Topic 2.3 - Variables
- 12 Excel VBA Topic 2.4 - Message Boxes & Input Boxes
- 13 Excel VBA Topic 2.5 - Absolute vs Relative References in VBA
- 14 Excel VBA Topic 2.6 - Recording Macros
- 15 Excel VBA Topic 2.7 - Making Better Use of Space
- 16 Excel VBA - Introduction to Topic 3
- 17 Excel VBA Topic 3.1 - Data Types
- 18 Excel VBA Topic 3.2 - Constant Variables
- 19 Excel VBA Topic 3.3 - Built-in Functions in VBA
- 20 Excel VBA - Introduction to Topic 4
- 21 Excel VBA Topic 4.1 - Sub Procedures
- 22 Excel VBA Topic 4.1.1 - Example, Calling a Sub Procedure
- 23 Excel VBA Topic 4.1.2 - Example, Reusing a Sub Procedure
- 24 Excel VBA Topic 4.2 - Variable Scope and Variable Lifetime
- 25 Excel VBA Topic 4.3 - Passing By Reference vs Passing By Value
- 26 Excel VBA - Introduction to Topic 5
- 27 Excel VBA Topic 5.1 - Function Procedures
- 28 Excel VBA Topic 5.2 - Customized Worksheet Functions
- 29 Excel VBA Topic 5.3 - Procedures within Procedures
- 30 Excel VBA - Introduction to Topic 6
- 31 Excel VBA Topic 6.1 - Relational and Logical Operators
- 32 Excel VBA Topic 6.2 - If-Then Structures
- 33 Excel VBA Topic 6.3 - If-Then-Else Structures
- 34 Excel VBA Topic 6.4 - If-Then-ElseIf Structures
- 35 Excel VBA Topic 6.5 - Select Case Structures
- 36 Excel VBA Topic 6.6 - Flowcharts
- 37 Excel VBA Topic 6.7 - Nested Decision Structures
- 38 Excel VBA - Introduction to Topic 7
- 39 Excel VBA Topic 7.1 - Introduction to Repetitive Execution (Loops)
- 40 Excel VBA Topic 7.2 - For Loops
- 41 Excel VBA Topic 7.3 - Do While & Do Until loops
- 42 Excel VBA Topic 7.4 - Nested Loops
- 43 Excel VBA Topic 7.5 - Using Loops with Worksheets
- 44 Excel VBA - Introduction to Topic 8
- 45 Excel VBA Topic 8.1 - Introduction to UserForms
- 46 Excel VBA Topic 8.2 - UserForm example with OptionButton and ComboBox
- 47 Excel VBA - Introduction to Topic 9
- 48 Excel VBA Topic 9.1 - 1D Arrays (vectors)
- 49 Excel VBA Topic 9.2 - Multidimensional Arrays (matrices)
- 50 Excel VBA Topic 9.3 - Passing Arrays to Procedures
- 51 Excel VBA Topic 9.4 - Dynamic Memory Allocation (ReDim statement)
- 52 Excel VBA - Final Thoughts
