MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

VBA Fundamentals

Course Summary

This course will help developers of any level get the most out of the Visual Basic for Applications (VBA) environment. Starting with the development environment and working through various aspects of the language, you will learn the tools and techniques n


  • +

    Course Syllabus

    ● Introduction to VBA Fundamentals
        ◦ Introduction
    ● The VBA Environment
        ◦ Introduction
        ◦ Configuring for Development
        ◦ The Developer Tab
        ◦ Macro Security
        ◦ The Visual Basic Editor: The Macro Recorder
        ◦ The Visual Basic Editor: The Standard Toolbar
        ◦ The Visual Basic Editor: The Project Explorer
        ◦ The Visual Basic Editor: The Properties Window
        ◦ The Visual Basic Editor: The Editor Window
        ◦ The Visual Basic Editor: The Edit Toolbar
        ◦ The Visual Basic Editor: The UserForm Toolbar
        ◦ The Object Browser
        ◦ The Debugger: The Debug Toolbar
        ◦ The Debugger: The Immediate Window
        ◦ The Debugger: The Locals Window
        ◦ The Debugger: The Watch Window
        ◦ The Debugger: The Call Stack
        ◦ The Debugger: Compiling Code
        ◦ Developer Add-Ins
        ◦ Summary
    ● The VBA Language, Part 1
        ◦ Overview
        ◦ The VBA Project and Components
        ◦ Data Types
        ◦ Objects
        ◦ Operators
        ◦ Essential Functions
        ◦ Summary
    ● The VBA Language, Part 2
        ◦ Overview
        ◦ Language Constructs
        ◦ Control Flow
        ◦ Extending VBA
        ◦ Summary
    ● The Object Model
        ◦ Overview
        ◦ Application Object
        ◦ Active Objects
        ◦ Custom Objects
        ◦ Collections
        ◦ Custom Collections
        ◦ Dialogs
        ◦ Summary
    ● The Event Model
        ◦ Overview
        ◦ Windows Messages
        ◦ VBA Events
        ◦ Declaring Variables With Events
        ◦ UserForm Events
        ◦ Summary
    ● Debugging and Error Handling
        ◦ Overview
        ◦ DebugPrint
        ◦ DebugAssert
        ◦ Trap
        ◦ Trace
        ◦ Writing an Error Handler
        ◦ VBA Error Trapping Settings
        ◦ Errors and the Call Stack
        ◦ Demo
        ◦ Summary
    ● Putting it Together
        ◦ Overview
        ◦ The Quick Access Toolbar
        ◦ The Office Fluent User Interface
        ◦ Demo 1 - Step by Step
        ◦ Demo 2 - Boxes
        ◦ Demo 3 - Dynamic Ribbons
        ◦ Which Customization?
        ◦ RibbonX in Microsoft Access
        ◦ Project Types
        ◦ Automatically Starting an Application
        ◦ Adding Polish
        ◦ Summary
        ◦ Course Summary

     


Course Fee:
USD 29

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top