Microsoft Excel Visual Basic for Applications

Course

In Worthing

Price on request

Description

  • Type

    Course

  • Location

    Worthing

  • Duration

    2 Days

Facilities

Location

Start date

Worthing (West Sussex)
Austin Clark Systems Ltd. 34a Forest Road, BN14 9NB

Start date

On request

About this course

A good working knowledge of the skills acquired in the advanced course. It is a good idea to check the advanced outline first.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Basic

Course programme

Training Course Outline:

Creating Record Macros

  • Recording a Macro
  • Running a Macro
  • Running a Macro from the Macros Dialog Box
  • Creating a Short-cut key to run a macro
  • Running a Macro with a Shortcut key
  • Assigning a Macro to a Menu or Toolbar
  • Editing a Macro with Visual Basic

Visual Basic Editor

  • Objects
  • Methods
  • Properties
  • Programming Tools
  • The Menu Bar

The Project Explorer

  • Using the Project Explorer

The Properties Window

  • Changing a Property

Using Constants

  • Excel Constants
  • Variable Constants

Excel Objects

  • Objects, Properties and Methods
  • Getting & Setting Properties
  • Calling Methods
  • Passing Arguments
  • Singular Objects & Collections of Objects

Variables

  • Dimensioning a variable
  • Using variables in routines
  • Object Variables

Using Visual Basic Functions

  • InputBox Function
  • MsgBox Function
  • Using a Set Statement

Building Formulae

Control Structures

  • If…Then Decision Structures
  • Logical Operators
  • Select Case Decision Structures
  • Case Else
  • Comparison Operators with Select Case Structure
  • For… Loops
  • Do Loops
  • While...Wend Statement

UserForms

  • Designing & Creating Forms
  • Working with Controls
  • Creating Custom Dialog Boxes
  • Userform Properties Methods & Events

Event Handling

  • VBA Editing & Debugging
  • Auto Macros
  • Error Handling

Microsoft Excel Visual Basic for Applications

Price on request