Excel VBA

Course

In London

£ 550 + VAT

Description

  • Typology

    Course

  • Location

    London

  • Duration

    2 Days

Description

On completion of this course the user will be able to design, write and debug Excel Visual Basic macros, create a dialog box and suitable control structures, and create custom Excel functions.
Suitable for: This 2-day course is aimed at experienced Excel users, preferably with some awareness or experience of computer programming.

Facilities

Location

Starts

London
See map
3-5 Crutched Friars, EC3N 2HR

Starts

On request

Questions & Answers

Ask a question and other users will answer you

Who do you want to respond to your question/enquiry?

We will only publish your name and question

Course programme

This 2-day course is aimed at experienced Excel users, preferably with some awareness or experience of computer programming. On completion of this course the user will be able to design, write and debug Excel Visual Basic macros, create a dialog box and suitable control structures, and create custom Excel functions.All the Open Scheduled VBA courses delivered by PPI Learning are suitable for all delegates no matter what version of Office they are working with in their own company's environment. We have chosen the middle ground as the delivery mechanism; so all VBA course will be delivered using Office 2000. If a specific version of VBA is required, then a private VBA course will need to be arranged with the PPI Learning Sales Executive.Course content

  • Recording Macros in Excel
  • Saving Macros for use with the Current File or All Excel Files
  • Assigning Shortcuts
  • Recording With Absolute or Relative References
  • Assigning Macros to Buttons or Shapes on a Worksheet
  • Assigning Macros to Toolbar Buttons
  • Adding Controls to a Worksheet
  • Creating Custom Excel Functions
  • The Visual Basic Editor
    • The Project Explorer
    • The Properties Window
    • Visual Basic Modules
    • Editor Options
    • Editor Views
  • Editing Visual Basic Code
  • Creating Toggle Macros

The Concepts of Object-Oriented Programming

  • Visual Basic Syntax
  • The Structure of Procedures
  • The Declaration Section
  • Comments
  • Keywords
  • Indenting Code
  • Navigating Code Using the Keyboard
  • Bookmarks
  • The Last Position Command
  • Getting Assistance from the Editor when Entering Code

Declaring Variables

  • Variable Scope
  • Variable Type
  • Type Conversion Functions
  • Constants
  • Arrays

Control Structures

  • The With Statement
  • If Statements
  • Select Case
  • Do Loop
  • For Next Loops

User Interaction

  • The MsgBox Statement
  • The InputBox Function
  • Creating UserForms

Working with Form Controls and the Control Toolbox

  • Adding Code to Forms
  • Displaying Forms with Module-Based Code
  • Pausing Code Execution
  • Locating Errors in Code
  • Handling Run-Time Errors
  • Setting Bookmarks
  • Setting Breakpoints
  • Tracing the Execution Path Using the Call Stack
  • Setting Watches
  • Viewing Variable and Array Values in Break Mode

Excel VBA

£ 550 + VAT