Advanced Microsoft Excel VBA for Business Manual Outline

Over 1000 pages of useful Excel VBA programming strategies including an extensive Excel VBA overview, data processing, automated charts, custom worksheet functions, advanced dashboards, userform design, events, database communication and commanding Word and PowerPoint for report generation

Call us at:   1.805.498.7162     1.805.558.9277--

Learn about how we can help your company or yourself achieve your Microsoft Excel training or self-study goals Visit our free Microsoft Excel and Microsoft Excel VBA resource center Learn how we can help save your company money with our innovative software solutions Visit out VBA code center for code that can save your company money Learn about our Excel Add-In software that can save your company time and money View our customer list from our 12 years in business Phone numbers, request form and email address Learn about EMAGENIT View our training schedule for Microsoft Excel and Microsoft Excel VBA

Microsoft Excel Beginning VBA for Business (Modules 12-15)

*All business manuals are derived from Microsoft Excel-Aided Business. Therefore depending upon the manual, some modules will not be included.

Module: Introduction

Key Module Topics:

  • Copyright and support information
  • Mouse terminology
  • Digital manual and example organization
  • Where to find the Excel examples

Module 12: VBA Editor and Module Basics

Key Module Topics:

  • Overview of how VBA can help in business tasks
  • VBA editor overview including VBA project, module and procedure overview
  • Controlling and typing in VBA modules
  • Referencing and integrating VBA projects
  • Using the VBA debugger to debug your code

Module 13: VBA Language Review

Key Module Topics:

  • VBA variables, constants and arrays (declaring, scope and data typing)
  • VBA operators (logical, arithmetic and comparison)
  • Control structures (loops and logic decisions)
  • Overview of Excel objects, properties and methods
  • How to identify and command Excel objects using VBA
  • How to use Excel/VBA on-line help
  • How to use the VBA macro recorder to record Excel business tasks in VBA
  • How to use the Object Browser
  • How to error proof your VBA code
  • How to command Workbook, Worksheet and Range objects using VBA
  • Automated chart construction
  • Data processing techniques
  • Dashboards for Excel

Module 14: VBA Function Procedure Design

Key Module Topics:

  • Benefits of using Function procedures and User Defined Worksheet Functions (UDF's) for business tasks
  • Function procedure and UDF differences
  • How to declare Function procedures and UDF’s in VBA
  • How to create arguments for Function procedures and UDF’s
  • How to call UDF’s from a worksheet formula
  • Calling Function procedures from other VBA procedures
  • Function procedure and UDF procedure interface design
  • How to pass worksheet ranges as arguments to UDF's
  • Returning scalar and array values from UDF’s to worksheet formulas
  • Using VBA and Excel Worksheet functions in your VBA procedures

Module 15: VBA Sub Procedure Design

Key Module Topics:

  • Benefits of using Sub procedures for business tasks
  • Declaring Sub procedures in VBA
  • Creating arguments for Sub procedures
  • Calling Sub procedures from other VBA procedures
  • Executing Sub procedures via the Macro dialog box
  • Executing Sub procedures via shortcut keys
  • Executing Sub procedures via graphics
  • Executing Sub procedures via events
  • Sub procedure interface design
  • Sub procedure design tips
  • Property procedure overview

Microsoft Excel Advanced VBA for Business (Modules 16-18)

Module 16: Graphical User Interface and Tool Packaging Design

Key Module Topics:

  • Developing business GUI's and applications in Excel
  • Creating graphics that display business data on the worksheet
  • Assigning VBA Sub procedures to worksheet based graphics
  • Using ActiveX and Form controls to create GUI’s on the worksheet
  • Creating event procedures for controls placed on a worksheet
  • Business wizard overview
  • Using userforms to create business wizards
  • Creating userforms in Excel
  • Creating controls and graphics on userforms
  • Commanding userforms and controls with VBA
  • Business wizard design tips
  • Creating toolbars and menus to control your Excel tools
  • Controlling Excel’s toolbar and menu system with VBA
  • How to create and package Excel tools

Module 17: Commanding Databases and Applications Using VBA

Key Module Topics:

  • OLE automation overview
  • How to command other applications from Excel using VBA
  • How to use CreateObject to control other applications
  • Using DDE with VBA
  • How to use DAO to communicate with Microsoft Access
  • How to use ADO to communicate with Databases
  • How to use ADO to communicate with Microsoft Excel
  • How to use ADO to communicate with Text Files
  • How to use the FileSystemObject to communicate with Windows file system
  • How to open multiple workbook files using the FileSystemObject
  • How to control Window's Shell
  • How to control Microsoft Word
  • How to control Microsoft PowerPoint

Module 18: VBA /ActiveX DLL Programming

Key Module Topics:

  • Object and class review
  • Practical uses of objects
  • Object method and properties overview
  • VB project overview for ActiveX DLL's
  • How to create an ActiveX DLL
  • Creating and naming your class modules
  • Designing object properties
  • Designing object methods
  • Designing object enums
  • Designing object hierarchies
  • How to reference your ActiveX DLL's from a VBA or VB project and distribute them
  • How to create and run your objects from Visual Basic
  • How to create and run your objects from VBA via Microsoft Excel
  • How to package and distribute your Active X DLLs

 

 

Additional Pages

Microsoft Excel Classes  Microsoft Excel VBA Courses  Microsoft Excel Training  Microsoft Excel Macros  Microsoft Excel VBA Consulting  Microsoft Excel Add-Ins

Copyright © 2002-2011 EMAGENIT All Rights Reserved