Microsoft Excel 2007 VBA Training Course in London and the UK
Our Excel 2007 VBA course help you create automated spreadsheets for all those repetitive tasks. Excel VBA can also help to simplify complex tasks that needs to be performed on a regular basis. At the end of the course, users will be able to record and run macros, edit the VBA code, build in loops structures and create custom forms. We also cover error handling and event procedures.
Our Excel 2007 VBA training course will also guide you through the differences of Excel VBA 2003 to 2007.
If you are not sure about the correct level of course in Excel 2007, please contact us. We can provide a Excel training needs analysis to identify the correct level. Remember, Mouse Training is run by trainers. We will understand your needs and will create a tailored Excel VBA course.
Let our expert Excel 2007 VBA trainers show you some truly remarkable tools in Excel.
Excel 2007 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 2007 VBA Course. Course starts at 09:30 and runs until 16:30
Excel 2007 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 Locations / Schedule
This course can be run Onsite, at our Excel 2007 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 2007 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
Excel 2007 Courses
