Embedded Files
INTRODUCTION TO VBA/MACROS IN EXCEL
Uses of learning Macros
What is Macro?
What is VBA ?
Difference between VB/VBA/VBS
How to enable Developer Tab
How to save the Macro file
How to open VBA Editor and what is the shortcut key?
TYPES OF WINDOWS IN VBA EDITOR
Project Explorer Window
Properties Window
Code Window
Sheet code window Module code window Userform class code window
Immediate window
Object browser
PROJECT EXPLORER WINDOW
What is project Explorer window
How to Open it?
PROPERTIES WINDOW
What is Property window?
How to open it?
How to open object properties
What is the different between XI SheetVisible, XI SheetHidden and XI sheet Very Hidden?
WHAT IS CODE WINDOW ?
How to create sheet code window ?
How to create module code window?
How to create user form code window?
How to create class code window?
WHAT IS MODULE?
What is the difference between sheet code and module code?
WHAT IS OBJECT ?
Object Model
Properties
Methods
Events
Syntax for Method with arguments
Syntax for Method without arguments
Syntax for Property
Realtime examples on methods and properties
How to open Object Browser
8.IMMEDIATE WINDOW
What is Immediate Window?
How to use it?
9.WHAT IS PROCEDURE?
Sub Procedure
Function Procedure
10. SUB PROCEDURE
Synonyms for Procedure
How to start and end a Macro
How to create a simple Macro
Macro naming conventions
11.DIFFERENT WAYS TO RUN A MACRO
Using Play Button
Using Default Shortcut Key
Run macro from Developer Tab
Assigning our own shortcut key to Macro
Assign Macro to other objects {Images , shapes , Button etc.}
Create New Group/New Tab to assign the macro
12. WHAT IS RECORD
Advantages
Disadvantages
13. DIFFERENCE TYPE OF ERRORS
Compile Errors
Run Time Errors
Logical Errors
14. REFERENCE STYLES
Range
Worksheet
Workbook
15.DIFFERENCE WAYS TO WORKING WITH CELLS
ActiveCell
Selection
Range method
Cells method
Square Bracket Method[]
Page updated
Google Sites
Report abuse