Macros VBA Topics Covered
Macros VBA Topics Covered | ||
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 |
||
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 ~ 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 | ||
Module 7: User Forms | ||
~ Creating forms ~ Form events ~ Creating custom menus and toolbars |