Excel VBA Programming

WWP Training Ltd.
Windsor, Berkshire, United Kingdom

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' This programme is for you if you already have a thorough understanding of Excel formulae and functions and may already use some Visual Basic programming, but now you are looking for a more professional result using Excel. This programme has been specially designed for advanced users who want to exploit the more powerful features of Excel made available by VBA.

In this programme, you will explore the VBA language and you will be encouraged to write programs to ensure that future editing, amending, and updating can be carried out with the minimum of effort. This is a generic programme and is suitable for users of any version of Excel.

Prerequisites
Excel users who are confident in their use of the commands, functions, and simple macros gained by prior attendance on an ‘advanced�Excel programme or as a result of user experience.

Programme Focus
Introduction to macros
�What is a macro?
�Recording and running a macro
�Relative and absolute macros
�Assigning a macro to a button on a worksheet or toolbar
�Button image editor
Editing macros
�The Visual Basic editor
�The project explorer
�The code window
�Procedures
�Inserting comments
�Printing a Visual Basic module
The range object
�What is the range object?
�The cells and range properties
�Flexible ranges
�Range contents
Workbooks and worksheets
�Activating a workbook and worksheet
�This workbook
Objects, properties and methods
�Controlling objects with their properties
�Performing actions with methods
�Performing multiple actions on an object
Variables and constants
�Control structures
�Conditional control structures
�Looping control structures
�Sub-proceduresControls and dialogue boxes
�Built-in dialogue boxes
�Pre-defined dialogue boxes
Storing information
�The Windows registry
�Settings files
Toolbars and display
�About toolbars and menus
�Attaching toolbars to workbooks
�Saving more than one toolbar configuration
�Customised toolbars
�Display techniques
Debugging and error trapping
�What are errors?
�Types of error
�Break mode
�Instant watch
�Stepping through code
�Error handling
Worksheet and workbook events
�Function procedures
�User-defined functions
Add-in applications
�What is an add-in?
�Creating an add-in
�Converting an add-in to a workbook
...''

Phone:01753 857 828

School Address:

WWP Training Ltd.
39-45 Victoria Street
Windsor
Berkshire
SL4 1HE
UK


Jobs & Resumes: Windsor
Houses & Roommates: Windsor

Search other schools for Excel VBA Programming training resources.

Outlook 2007 Advanced
Outlook 2007
Access 2007 Application Development
Access 2007
Access Queries and Reports
PowerPoint 2007
Excel 2007
Word 2007
MS Project 2007
Dreamweaver CS3
Fireworks CS3
Flash CS3
Photoshop CS3
FrontPage
Visio
QuarkXpress

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Try the search form on top of each page to find the latest course information, using course topic and location as keywords. Keep the course topic keyword short to get more results.