Course

In London

£ 550 + VAT

Description

  • Type

    Course

  • Location

    London

  • Duration

    2 Days

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

Start date

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

Start date

On request

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

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