Excel Visual Basic
Categories: Microsoft Excel
Excel Visual Basic

Course Contents
The contents of our Excel Visual Basic course are as follows (any items marked with a * will be covered if time allows).

Not only our best-selling course, but also one of our favourites. This two-day course takes you through Visual Basic for Applications in Excel from recording macros through to advanced form design. On the way you will learn how to write object-oriented programs and how to create loops and implement error-handling. Microsoft Excel macros are fun - let us show you why!

Recording macros and buttons
• Absolute and relative recording
• Where macros can be stored
• Assigning macros to buttons

Selecting cells
• Selecting cells (absolute)
• Selecting cells (relative)
• Selecting to the end of a block
• Selecting a range by its corners

The VB code editor
• Using Project Explorer
• Creating modules
• Basic subroutines and comments

Messages and variables
• Input boxes and message boxes
• Declaring variables
• Option Explicit
• Scope of variables
• Constants

Visual Basic explained
• The Excel object model
• Objects and collections
• Methods and properties
• Getting help in VBA

Loops and conditions
• Simple IF conditions
• Multiple IF and SELECT CASE
• Three main types of loop

Looping over collections
• Object variables
• Looping over collections Event handling
• Assigning macros to events
• Cancelling events

Functions (*)
• Declaring functions
• Passing arguments

Debugging and error handling
• Setting breakpoints
• Stepping through macros
• ON ERROR statements

Forms
• Drawing forms
• Attaching macros to controls
• Validating form input

Referencing other applications (*)
• Links to Word or Access
• Working with files and folders

Working with files (*)
• Using FileSystemObjects
• Working with files and folders
• Using FileDialogs

Revision exercises (*)
• Exercises for after the course
 
Course Dates
Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...  
1-17 of 17
Tip: Click column names to sort. Click start dates to see scheduled days
LocationDistance (approx)Course Start DateNo. DaysWeb price ex.VATCourse Status 
Manchester 198 miles Tue 13 Jan 09 2£550      CLICK TO ENQUIRE
    CLICK TO BOOK
Edinburgh430 miles Wed 28 Jan 09 2£550      CLICK TO ENQUIRE
    CLICK TO BOOK
London - New Broad Street3 miles Tue 10 Feb 09 2£550      CLICK TO ENQUIRE
    CLICK TO BOOK
Newcastle281 miles Thu 12 Feb 09 2£550      CLICK TO ENQUIRE
    CLICK TO BOOK
Birmingham - Victoria Square118 miles Tue 17 Feb 09 2£550      CLICK TO ENQUIRE
    CLICK TO BOOK
Manchester 198 miles Wed 25 Feb 09 2£550      CLICK TO ENQUIRE
    CLICK TO BOOK
London - New Broad Street3 miles Thu 26 Feb 09 2£550      CLICK TO ENQUIRE
    CLICK TO BOOK
Manchester 198 miles Thu 26 Mar 09 2£550      CLICK TO ENQUIRE
    CLICK TO BOOK
Manchester 198 miles Wed 15 Apr 09 2£550      CLICK TO ENQUIRE
    CLICK TO BOOK
Birmingham - Victoria Square118 miles Tue 28 Apr 09 2£550      CLICK TO ENQUIRE
    CLICK TO BOOK
Manchester 198 miles Thu 21 May 09 2£550      CLICK TO ENQUIRE
    CLICK TO BOOK
Leeds194 miles Thu 28 May 09 2£550      CLICK TO ENQUIRE
    CLICK TO BOOK
London - New Broad Street3 miles Tue 02 Jun 09 2£550      CLICK TO ENQUIRE
    CLICK TO BOOK
London - New Broad Street3 miles Tue 09 Jun 09 2£550      CLICK TO ENQUIRE
    CLICK TO BOOK
Manchester 198 miles Mon 29 Jun 09 2£550      CLICK TO ENQUIRE
    CLICK TO BOOK
Manchester 198 miles Tue 07 Jul 09 2£550      CLICK TO ENQUIRE
    CLICK TO BOOK
London - New Broad Street3 miles Wed 09 Sep 09 2£550      CLICK TO ENQUIRE
    CLICK TO BOOK
Tools
 
Key Details
Duration2 days
 
£550
per delegate