Learn Excel VBA Macros

Introduction to VBA, Importance of Developer Tab and VB window, 

Path to get into VB window

Introduction to different windows in VB

1. Project Explorer

2. Property Window

3. Code Window

Types of Code window

1. Sheet Code Window

2. Workbook Code Window

3. Module Code Window

4. User form Code Window

• Introduction to object
• Introduction to property and methods
• Importance of arguments
• Object Browser Procedures
  • Sub Procedure
  • Function Procedure
• Coding Structure
• Introduction to Cell Reference
• Usage of different property and methods with cells
• Introduction to sheet reference
• Usage of different property and methods with sheets
• Assigning Comments & Breakpoint.

• Introduction to workbook reference
• Usage of different property and methods with workbook
• Introduction of variable declaration
• Importance of different data types
• Scope and Ways of declaration of variables.

• Loop Statements
• Introduction to Message Box,
• Introduction to Input Box,
• Introduction to different Loop statements
  • For Next
    • Forward Loop
    • Reverse Loop
    • Step Value
  • Multi loop

• Introduction to conditional statement
  • IF, AND , OR
  • Case Statement
• Activity on different conditional statement,
• Activity on different conditional statement with LOOP,
• Select case decision structure,
• Activity on select case structure

• Introduction to GOTO Label command
• Activity on GOTO label command

• Introduction to TO_DOLOOP
• DO_WHILE LOOP
• Activity on DO_WHILE LOOP
• DO_UNTIL LOOP
• Activity on DO_UNTIL LOOP
• Introduction to FOR EACH NEXT LOOP
• Usage of SET statement
• Usage of WITH Command
• Activity on FOR EACH NEXT LOOP
•  

• Segregation of data in static way
• Introduction to Last row number and last column number
• Segregation of data in dynamic way
• Consolidation of Data in dynamic way
•  

• Introduction VBA & Worksheet Functions
• Error Handling Concepts
•  

• Selecting file & folder from different paths in a dynamic way

• Introduction to USER DEFINED function
• Activities on USER DEFINED function
• UDF on extracting numbers
• UDF on extracting data

• Record Macro
• Running a Macro
• Running a Macro from the Macros Dialog Box
• Creating a short key to run Macro
• Running a Macro with a short key
• Assigning a Macro to a menu or tool bar
• Editing a Macro with VB

• Designing and Creating Forms
• Working with controls
• Creating custom dialog boxes
• User forms properties
• Methods and Events

• Connection with Other Applications
  • Using Early Binding
  • Using Late Binding
• Connection with
  • Outlook Application
  • Internet Explorer