Microsoft Excel 2003 VBA Training Course in London and the UK
With our Excel 2003 VBA training course, you will learn how to manage your macros to automate repetitive tasks, or simplify more complex tasks. As the most commonly used version of Excel, our 2003 macros course is extremely popular with our clients, which includes HSBC, Google, QBE and many other companies.
By attending our Excel 2003 Visual Basic course you will not only save time, but also money. A recent comment from a client said that after attending the course, they saved more than 100hrs per project per year! WOW - what an improvement.
The Excel 2003 VBA course can be tailored to suit your needs. If you are not sure if this is the correct course for you, then please contact us. As part of our service, we offer free Training Needs Analysis and course tailoring. We never sell something you don't need.
Excel 2003 VBA Macros Training Course Information
Audience: This course is aimed at experienced Excel users who need to automate repetitive tasks or simplify more complex tasks using macros and VBA.
Course Duration: This is a 2 day Excel 2003 VBA Course. Course starts at 09:30 and runs until 16:30
Excel 2003 VBA Course Objectives: After the course, you will be able to:
- Record / Run Macros
- Write Code Manually
- Perform Loops, Controls and Error Handling
- Create UDF Functions and Add-ins
- Create User forms and Sheet Controls
- Use Events
Requirements: You must have sound Excel skills and understand key concepts of spreadsheets, or equivalent to our advanced course level.
Course Duration
This is a 2 day Excel 2003 VBA Course. Course starts at 09:30 and runs until 16:30
Course Locations / Schedule
This course can be run Onsite, at our Excel training centre or any preferred location in the UK. The course is run on a date that suits you! We do not run public scheduled courses.
Excel 2003 VBA Macros Training Course Contents
Concept, Recording and Running Macros, the VBE Environment
- The Project Window
- Code Window
- Properties Window
- Navigating between Excel and the VB Editor
Editing Code + Methods of Executing
- Using the Visual Basic Editor
- Structure of a sub routine
- Key Words
- Navigation in a Module
- Editing in a module
- Use of Function Keys
- Run subroutines together
- Menu, Visual Basic Toolbar, Keyboard Shortcut, Custom Toolbar Button, Custom Menu Item, Forms Toolbar executing
Visual Basic Language Rules
- Theory of Object
- Properties and Methods
- Active Objects
- Object Model Hierarchy
- Inheritance
Control Structures
- IF, Nested IF
- AND OR NOT
- SELECT CASE
- Inbuilt Functions
- Distribution, Watch Pane
- Step through Functions using the immediate Window
Looping Structures
- Do Loops
- For Next Loops
- For Each Next Loops
Interactive Macros
- Msgbox
- Conditional Message Box
- Inputbox
Interactive Macros
- Msgbox
- Conditional Message Box
- Inputbox
Creating Interactive Forms
- Form Controls
- User forms
- Using the Properties Window
- Combo box
- Radio Buttons
- Group box
- Check box
- Built in Dialog Boxes
- Creating Custom Menus
- Creating Custom Toolbars
Events
- What are Event Procedures?
- On Open
- Before Close
- On Activate
- On Deactivate
- On Key
- On Time
Security
- Protecting/locking code for view/edit
- Digital Signatures
**Our Excel 2003 VBA Course can be tailored to your needs. Include/Exclude as much content from other courses as required**
Excel 2003 Courses
