COURSE SEARCH
 
   HOME > COURSES > MICROSOFT EXCEL 97 VISUAL BASIC FOR APPLICATIONS MEMBERS LOGIN 
UNLIMITED ACCESS TO OVER 575 ONLINE TRAINING COURSES FOR ONE ANNUAL PAYMENT OF ONLY $149 USD
BUY NOW
  HOME     COURSE LIBRARY     QUESTIONS & ANSWERS     CONTACT US
There are many excellent online courses. This has been hugely beneficial in my day to day work.
- Louise Nolan


Microsoft Excel 97 Visual Basic for Applications




Course Aims
This course has been specially designed for advanced user who wants to make use of the more powerful facilities of MS Excel 97 made available by VBA. This course explores VBA language and readers will be encouraged to write programs to ensure that future editing, amending and updating can be carried out with the minimum of effort.
Assumed Knowledge
Excel 97 users who are confident in their use of the commands, functions and simple Macros gained by prior attendance on an "MS Excel 97 Advanced" course or via user experience.
Course Audience
Existing Excel 97 power users who wish to utilise the VBA to develop more sophisticated applications.

This course can be found in the following categories:
Courses > Programming > Microsoft VBA
Courses > Microsoft > Office 97
Courses > Microsoft > Visual Basic
Courses > Microsoft > Excel

Table of Contents
Introduction
  		• What is a Macro?
  		• Recording a Macro
  		• Running a Macro
  		• Relative References
     
    Assigning Macros to Buttons and Objects
  		• Assigning a Macro to a Button on a Sheet
  		• Assigning a Macro to a Drawn Object on a Sheet
  		• Assigning a Macro to a Button on a Toolbar
     
    Editing Macros
  		• The Visual Basic Editor
  		• The Project Explorer
  		• The Code Window
  		• Procedures
  		• Inserting Comments
  		• Printing a Visual Basic Module
     
    The Range Object
  		• The Cells Property
  		• The Range Property
  		• Flexible Ranges
  		• Range Contents
     
    Workbooks and Sheets
  		• Activating a Workbook
  		• Activating a Worksheet
  		• ThisWorkBook
     
    Objects, Properties and Methods
  		• Controlling Objects with their Properties
  		• Performing Actions with Methods
  		• Performing Multiple Actions on an Object
     
    Variables and Constants
  		• Variables
  		• Data Types
  		• Constants
     
    Control Structures
  		• Conditional Control Structures
  		• Looping Control Structures
  		• Non-Structured Statements
  		• Subprocedures
    Controls, Dialogue Boxes and Forms
  		• Built-In Dialogue Boxes
  		• Predefined Dialogue Boxes
  		• Custom Forms
  		• Worksheet Forms
  		• User-Defined Forms
  		• Adding Form Controls
  		• Form Control Properties
  		• Control and Dialogue Box Events
  		• Displaying and Dismissing a User Form
  		• Handling Form Controls
     
    Storing Information
  		• The Windows Registry
  		• Settings Files
  		• WritePrivateProfileString
     
    Toolbars and Display
  		• About Toolbars and Menus
  		• Customised Toolbars
  		• Display
     
    Debugging and Error Trapping
  		• Errors
  		• Break Mode
  		• Instant Watch
  		• Stepping
  		• Error Handling
  		• Error Handling Example
     
    Worksheet and Workbook Events
  		• Worksheet Object Events
     
    Function Procedures
  		• User-Defined Functions
     
    Add-in Applications
  		• Creating an Add-In
  		• Converting an Add-In to a Workbook
     
    Appendix - Naming Conventions
  		• User Form Controls
  		• Memory Variables
    TRY BEFORE YOU BUY BECOME A RESELLER TERMS & PRIVACY
    Thursday 17th May 2012  © COPYRIGHT 2012 - website design by Website Design by Visualsoft