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 |