Microsoft Excel 2007 VBA Training Course

Product type
Level

Microsoft Excel 2007 VBA Training Course

Melton IT Services Ltd
Logo Melton IT Services Ltd

Need more information? Get more details on the site of the provider.

Description

This 2 day Microsoft Excel 2007 VBA training course will help students to become proficient application developers by using the features of Microsoft Excel 2007 and Visual Basic for Applications.(VBA)

Target audience

Students should have familiarity with personal computers and the use of the keyboard and mouse. They should have completed introduction, intermediate and advanced courses in Excel 2007 or have equivalent practical experience

Course contents

Getting Started

  • Introducing Visual Basic for Applications
  • Recording, running and editing a macro
  • Understanding the development environment
  • Understanding objects
  • Navigating the Excel object
  • Working with Statements, properties, event…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

This 2 day Microsoft Excel 2007 VBA training course will help students to become proficient application developers by using the features of Microsoft Excel 2007 and Visual Basic for Applications.(VBA)

Target audience

Students should have familiarity with personal computers and the use of the keyboard and mouse. They should have completed introduction, intermediate and advanced courses in Excel 2007 or have equivalent practical experience

Course contents

Getting Started

  • Introducing Visual Basic for Applications
  • Recording, running and editing a macro
  • Understanding the development environment
  • Understanding objects
  • Navigating the Excel object
  • Working with Statements, properties, events and methods

 Working with Procedures and Functions

  • Understanding and Creating a standard module; sub procedures and functions procedures

   Using Expressions, Variables and Functions

  • Understanding expressions and statements
  • Declaring variables, data types, scope of variables, Constants ,using spreadsheet functions.
  • Using message boxes
  • Using input boxes
  • Declaring and using object Variables

 Controlling Program Execution

  • Understanding control-of-flow structures
  • Working with Boolean expressions, Using if, Case; do loop, for next structures
  • Guidelines for use of control-of-flow structures

 Working with Forms and Controls

  • Using the toolbox
  • Working with User Form properties, events and methods, controls and properties
  • Understanding controls, using Label; text box; Command button; option button; combo box and
  • frame controls
  • Setting the tab order
  • Populating a control
  • Adding code to controls
  • Launching a form in code

 Debugging Code

  • Understanding errors and debugging tools
  • Setting breakpoints and stepping through code
  • determining the value of expressions

 Handling Errors

  • Understanding error handling and trapping
There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.