| |
Micros VBA Topics Covered |
| |
| Topics Coverd: |
| |
| Module 1: Understanding Security Levels |
| |
*
* |
Why security
Security levels and its meaning |
| |
| Module 2: Functions |
| |
*
*
* |
What is Function and Subroutine
Writing Functions using VBA Editor
Calling function in other workbook |
| |
| Module 3: Recording Macros |
| |
*
*
*
* |
Recording and running macro
Storing macro in different books
Creating buttons and assigning macro to it
Creating My Menu |
| |
| Module 4: The Visual Basic Editor |
| |
*
*
*
*
* |
Editing macros using VBA Editor
Understanding the project explorer
Exploring windows properties
Modifying code in code window
Debugging code |
| |
| Module 5: Programming Fundamentals |
| |
*
*
*
*
*
*
*
*
|
Variables, data types and constants
Arrays
Object Variables
Conditional structures (If …. Then, Select Case)
Logical Operators
Looping constructs (For loops, Do loops, while… Wend)
Built-in functions
Creating Subroutines |
| |
| Module 6: Excel Object Model |
| |
*
*
*
*
* |
Working with objects – properties, events and methods
Application objects
Workbook objects, Worksheet objects and Range objects
Charts objects
Pivot table objects |
| |
| Module 7: User Forms |
| |
*
*
*
* |
Creating forms
Form events
Creating custom menus and toolbars
Creating Add-ins |
| |
| Module 8: Working with other applications |
| |
*
|
Working Word, PowerPoint and other applications. |
| |
| |
+91-22-23676218 / 23671772