Excel 2010 VBA Training Course
Our Excel 2010 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 2010 VBA training course will also guide you through the differences of Excel VBA 2003 to 2010.
If you are not sure about the correct level of course in Excel 2010, 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 2010 VBA trainers show you some truly remarkable tools in Excel.
Excel 2010 VBA Macros Training Course Info
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 2010 VBA Course. Course starts at 09:30 and runs until 16:30
Excel 2010 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 2010 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 2010 VBA Macros Training Course Contents
The Concept, Record and Run Macros & the VB 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
- Navigate a Module
- Edit 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
- Using a Msgbox
- Use a Conditional Message Box
- Use the Inputbox
Create Interactive Forms
- Build Form Controls
- Build User forms
- Use of the Properties Window
- Combo box
- Radio Buttons
- Group box
- Check box
- Built in Dialog Boxes
- Create Custom Menus
- Create Custom Toolbars
Events
- What are Event Procedures?
- On Open event
- Before Close event
- On Activate event
- On Deactivate event
- On Key event
- On Time event
Security
- Protect/lock code for view/edit
- Digital Signatures
Excel 2010 Courses
