Microsoft Office Eğitimleri - Microsoft VBA

Visual Basic for Applications Outline

• Introduction
  • Definitions
  • Objectives

1. Programming in Excel
   • Procedures
   • Relative and Absolute References
   • Availability of Procedures
     • Personal Macro Workbook
2. Editing Recorded Procedures
   • Viewing Code
   • The Visual Basic Editor
   • Reading Code
   • Using Visual Basic Procedures
     • Interactive Procedures
     • Control Structures
     • Using Help
     • Customising Visual Basic
3. User Defined Functions
   • Creating and using User Defined Functions
4. Visual Basic Procedures
   • Using Procedures Together
   • Calling Procedures
   • Optional Arguments
   • Passing Arguments
   • Project Organisation
   • Protecting Procedures
   • Protecting Modules
5. Visual Basic Objects
   • Using Objects
   • Referencing and Using Properties
   • Common Properties
   • Using Methods
   • Collections
   • Object Browser
6. Visual Basic Code
   • Declaring Variables and Arguments
   • Data Types
   • Function Data Types
   • Assigning Objects to Variables
   • Scope and Life of Variables
   • Arrays
7. Control Structures
   • Conditional Structures
   • Repetition
   • Nesting structures
8. Testing and Debugging
   • Debugging Tools
   • Calls Stack
   • Watch Expressions
   • Immediate Pane
9. Error Handling
   • Error Handler Design
   • Error-Handling Hierarchy
   • Testing Error Handling
10. Object Models
    • Object Model Overview
    • Using Objects to Automate Tasks
11. Application Objects
    • Properties
    • Methods
    • Events
12. Data Access Objects
    • DAO Objects
    • Accessing ODBC Data
    • DAO with ODBCDirect
    • Using ODBCDirect
13. ActiveX Controls and Dialogue Boxes
    • Custom Dialogue Boxes
    • Controls
14. Optimising for Size and Speed
    • Optimisation Strategies
15. User Access
    • Menus
    • Toolbars
    • Command Buttons
16. Configuration Settings
    • Writing to the Registry
    • Reading from the Registry