Please enable JavaScript.
Coggle requires JavaScript to display documents.
Effective Excel VBA - Coggle Diagram
Effective Excel VBA
Project 2 - Code Design
Basic solution for our project
How to design your project
Project requirements
Using functions and subs to organize your code
Collections - a simple data structure
Putting it all together - the final code
Enums - How to make your code more readable
Basic Data Manipulation
How to Filter/Copy data records
The For Loop
How to read data records
Current Region
If Statement
For Each
Arrays Unleashed
Why we need arrays
Practical uses of 1D Arrays
Optimizing 2D Array Code
Getting Started with arrays
Copying arrays - important considerations
Replacing Ranges with 2D Arrays
Variables
What are variables
Declaring variables
Assigning values
Variable scope
Object variables
Object Model Hierarchy
Powerful Data Manipulation Tools
Advanced Filter Introduction
ADO Introduction
Scenario 1 using Advanced Filter(Filter and Copy)
ADO Guide
Scenario 1 to 3 using ADO(Filter/Group/Join)
Advanced Filter Guide
Accessing Worksheets
Opening a workbook for writing
Opening a workbook for reading
Selecting the correct worksheet
Troubleshooting
Accessing sheets in other workbooks
Perfomance Optimization
Introduction to performance Optimization
Optimiization Basics
How to measuring performance
Optimization for data manipulation
Key optimization techniques
Real-World Data Manipulation Scenarios
Useful data structures: The Dictionary
Scenario 2A: Grouping data
Scenario 3: Joining data
Scenario 1: Filltering and copying
Scenario 2B: Grouping with multiple fields
User Interaction
Introduction to User Interaction
Using buttons to run the code
Using Excel events to run code
Using the worksheet event in the real-world
Getting Started
VB Editor basics
Creating a sub
Writing values to a cell
Dealing with Multiple Workbooks
Retrieving multiple files from a folder
Using the Windows Open Dialog to select files
Introduction
Techniques for Clean Code
Indenting the code
Using With statement