EXCEL-VBA (MACRO PROGRAMMING) COURSE IN JAIPUR
FREE DEMO CLASSES
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 I. 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.
Placements of Thirdeye
