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
Log In
Good to see you again!
Username
Password
Remember Me
Login
Forgot your password? Get help
Privacy Policy
Or log in with
Login with
Facebook
Login with
Google
Login with
LinkedIn
Not a member?
Sign up
Create An Account
It's super easy. And it's FREE.
Your username
Your email
Password
Confirm Password
Register
Or register with
Login with
Facebook
Login with
Google
Login with
LinkedIn
Privacy Policy
Already a member?
Sign in
Reset Password
Submit your email address
Username or E-mail
Request Reset Password Link
A password reset link will be e-mailed to you.
Privacy Policy
Back to
Login
×