Automation With Excel Macros & VBA

Pre-Course Survey
Discussion Forum: Macros & VBA
Basics of Macro recording
4 Topics
Overview of Macro & Macro-enabled workbooks
Recording basic macros
Absolute vs. relative referencing during macro recording part-1
Absolute vs. relative referencing during macro recording part-2
Overview of VBA Procedures
 7 Topics
VBA & VBA Procedure
VBA Subroutine and VBA Functions
Example of VBA Subroutine
Example of VBA Function
Declaring Variables & It’s Scope
Data Types
Troubleshooting Codes
User Defined Functions in VBA
 10 Topics
VBA Expressions
VBA Built-In Functions
Making Own User-defined Functions & Example of User-defined Functions: Part-1
Making Own User-defined Functions & Example of User-defined Functions: Part-2
Making Own User-defined Functions & Example of User-defined Functions: Part-3
Making Own User-defined Functions & Example of User-defined Functions: Part-4
Creating Excel Add-in
Borrowing Excel Functions, Troubleshooting User Defined Functions & Input Box & Message Box In Functions
Modular Programming
Running a Sub from Another File
Transferring Info between Excel and VBA
 8 Topics
VBA Objects
VBA Objects Properties
VBA Objects Methods
VBA Object Events
Examples : Input & Output in Subs: part 1
Examples : Input & Output in Subs: part 2
Examples : Input & Output in Subs: part 3
Basic Error Handling in Subs
Programming structures in VBA
 10 Topics
One-Way If….Then Structure
Two-Way If….Then Structure
Multi-Way If….Then Structure
For….Next Loops
For Each….Next Loops
If….Then & For…. Loops Combination
If….Then & For…. Loops Combination
With…. Structure
Do…Loop Structure
Do…Loop & DoEvent combination
Arrays and Array Functions
 9 Topics
Introduction to Array
Local Arrays in VBA
Exchanging Data Between Excel & Array
Using Arrays in Subs vs Functions
User Defined Array Functions
String Functions in Excel
Using String Function in VBA
Example: String Function in VBA
Example: Array-String Function in VBA
Working with .txt files
 3 Topics
Creating a Blank Text File & Writing in a Text File
Exporting Data into a Text File
Importing Data from a Text File
Numerical Optimization Techniques
 5 Topics
Goal Seek Tool
Goal Seek Automation
Solver Tool
Solver Automation
Circular Calculation
Iterating through worksheets and workbooks
 10 Topics
All About Worksheets
Iterating Through Worksheets
Combining Multiple sheets into single sheet part-1
Combining Multiple sheets into single sheet part-2
Combining Multiple sheets into single sheet part-3
All About Workbooks
Opening Workbooks
Combining Multiple Workbooks into single workbook part-1
Combining Multiple Workbooks into single workbook part-2
Combining Multiple Workbooks into single workbook part-3
User forms and advanced user input/output
 14 Topics
Advanced Input Boxes
Advanced Message Boxes
Introduction to User Form part-1
Introduction to User Form part-2
Input Validation in User Form
Combo Box In User Form
Adding Data By User Form Into Excel
List Box In User Form
A Complete User Form Project: part-1
A Complete User Form Project: part-2
A Complete User Form Project: part-3
A Complete User Form Project: part-4
A Complete User Form Project: part-5
A Complete User Form Project: part-6
Final Project: VBA & Macros
User Feedback on This Course
Previous Topic

Absolute vs. relative referencing during macro recording part-2

Automation With Excel Macros & VBA Basics of Macro recording Absolute vs. relative referencing during macro recording part-2
Lesson Progress
0% Complete

Previous Topic
Back to Lesson
×

Cart