VBA using Excel

IT Training Solutions Limited

Course

Inhouse

Price on request

The best Visual Basic courses

See all

See all

Description

  • Type

    Course

  • Methodology

    Inhouse

This course is aimed at those people who find they have reached their limit with the menu items of Excel and need to modify Excel to be better suited to their environment, by creating their own functions and procedures.

About this course

Delegates must have a good grasp of Excel. Delegates should be at the stage whereby they can use a lot of the features of Excel, being a confident Excel user. Previous use of macros before would be an advantage but not essential.

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

Course Overview

This course is aimed at those people who find they have reached their limit with the menu items of Excel and need to modify Excel to be better suited to their environment, by creating their own functions and procedures.
Prerequisites
  • Delegates must have a good grasp of Excel.
  • Delegates should be at the stage whereby they can use a lot of the features of Excel, being a confident Excel user.
  • Previous use of macros before would be an advantage but not essential.


Objectives


    Delegates will be able to :
  • Go beyond the user interface of Excel into the Visual Basic for Applications component. This will allow delegates to be able to write/modify programs using Visual Basic for Applications. Delegates will be able to :
  • Control and manipulate Excel using Visual Basic Code
  • Create forms to enter data directly onto your spreadsheet
  • Write complicated macros to check spreadsheet data
  • Create functions that will perform complex calculations
Related Courses
  • Excel Level 1 ()
  • Excel Level 2 ()
  • Excel Level 3 ()
Training Options
  • Bespoke course (a course written to your specific needs) at your company office throughout the UK, at our training venue or at an independent location, convenient to you
  • Private course at your company office throughout the UK, at our training room or at an independent location, convenient to you
  • Scheduled public course at one of our training venues
Whats Included
  • Comprehensive colour course manual and exercises
  • Use of a Modern Training suite with 19 inch flat screen monitors
  • 1 delegate per computer
  • Lunch (When at our training venue)
  • Refreshments (When at our training venue)
  • Relaxed refreshment area at our training room
Course Content
Getting Started
  • Closing the Visual Basic editor
  • Using Visual Basic help
  • Understanding the development environment
  • Editing a macro in the visual basic editor
  • Running a macro
  • Recording a macro
  • Introducing visual basic for applications
Working with Procedures and Functions
  • Working with the code editor
  • Naming procedures
  • Creating a function procedure
  • Using the immediate window to call procedures
  • Calling procedures
  • Creating a sub procedure
  • Understanding procedures
  • Creating a standard module
  • Understanding modules
Understanding Objects
  • Creating an event procedure
  • Working with methods
  • Using the with statement
  • Working with properties
  • Using the object browser
  • Understanding collections
  • Navigating the Excel object hierarchy
Using Expressions, Variables, and Intrinsic Functions
  • Declaring and using object variables
  • Using input boxes
  • Using message boxes
  • Using intrinsic constants
  • Understanding constants
  • Using intrinsic functions
  • Working with variable scope
  • Understanding data types
  • Declaring variables
  • Understanding expressions and statements
Controlling Program Execution
  • Guidelines for use of control-of-flow structures
  • Using the for each...next structure
  • Using the for...next structure
  • Using the do...loop structure
  • Using the select case...end select structure
  • Using the if...end if decision structures
  • Working with boolean expressions
  • Understanding control-of-flow structures
Working with Forms and Controls
  • Launching a form in code
  • Adding code to controls
  • Populating a control
  • Setting the tab order
  • Working with control appearance
  • Working with: text box control, command button control, combo box control, frame control and option button controls
  • Working with the label control
  • Setting control properties in the properties window
  • Understanding controls
  • Working with UserForm properties, events, and methods
  • Using the toolbox
  • Understanding UserForms
Debugging Code
  • Determining the value of expressions
  • Using break mode during run mode
  • Stepping through code
  • Setting breakpoints
  • Using debugging tools
  • Understanding errors
Handling Errors
  • Working with inline error handling
  • Writing an error-handling routine
  • Understanding the err object
  • Trapping errors with the on error statement
  • Understanding VBA's error trapping options
  • Understanding error handling

See related categories

VBA using Excel

Price on request

The best Visual Basic courses

See all

See all