(619) 876-4224 x210 info@otstraining.org


Visual Basic for Applications enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). It supersedes and expands on the abilities of earlier application-specific macro programming languages such as Word’s WordBasic. It can be used to control many aspects of the host application, including manipulating user interface features, such as menus and toolbars, and working with custom user forms or dialog boxes.

Class Outline

Part I: Some Essential Background

  • Excel 2010: Where It Came From
  • Excel in a Nutshell
  • Formula Tricks and Techniques
  • Understanding Excel Files

Part II: Excel Application Development

  • What Is a Spreadsheet Application?
  • Essentials of Spreadsheet Application Development

Part III: Understanding Visual Basic for Applications

  • Introducing Visual Basic for Applications
  • VBA Programming Fundamentals
  • Working with VBA Sub Procedures
  • Creating Function Procedures
  • VBA Programming Examples and Techniques

Part IV: Working with UserForms

  • Custom Dialog Box Alternatives
  • Introducing UserForms
  • UserForm Examples
  • Advanced UserForm Techniques

Part V: Advanced Programming Techniques

  • Developing Excel Utilities with VBA
  • Working with Pivot Tables
  • Working with Charts
  • Understanding Excel’s Events
  • Interacting with Other Applications
  • Creating and Using Add-Ins

Part VI: Developing Applications

  • Working with the Ribbon
  • Working with Shortcut Menus
  • Providing Help for Your Applications
  • Developing User-Oriented Applications

Part VII: Other Topics

  • Compatibility Issues
  • Manipulating Files with VBA
  • Manipulating Visual Basic Components
  • Understanding Class Modules
  • Working with Colors

If you would like to register for a course, call (619) 876-4224 ext 210 or you may register online.