Microsoft Excel 2007 VBA Training Course
Description
This 2 day Microsoft Excel 2007 VBA training course will help students to become proficient application developers by using the features of Microsoft Excel 2007 and Visual Basic for Applications.(VBA)
Target audience
Students should have familiarity with personal computers and the use of the keyboard and mouse. They should have completed introduction, intermediate and advanced courses in Excel 2007 or have equivalent practical experience
Course contents
Getting Started
- Introducing Visual Basic for Applications
- Recording, running and editing a macro
- Understanding the development environment
- Understanding objects
- Navigating the Excel object
- Working with Statements, properties, event…
Frequently asked questions
There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.
This 2 day Microsoft Excel 2007 VBA training course will help students to become proficient application developers by using the features of Microsoft Excel 2007 and Visual Basic for Applications.(VBA)
Target audience
Students should have familiarity with personal computers and the use of the keyboard and mouse. They should have completed introduction, intermediate and advanced courses in Excel 2007 or have equivalent practical experience
Course contents
Getting Started
- Introducing Visual Basic for Applications
- Recording, running and editing a macro
- Understanding the development environment
- Understanding objects
- Navigating the Excel object
- Working with Statements, properties, events and methods
Working with Procedures and Functions
- Understanding and Creating a standard module; sub procedures and functions procedures
Using Expressions, Variables and Functions
- Understanding expressions and statements
- Declaring variables, data types, scope of variables, Constants ,using spreadsheet functions.
- Using message boxes
- Using input boxes
- Declaring and using object Variables
Controlling Program Execution
- Understanding control-of-flow structures
- Working with Boolean expressions, Using if, Case; do loop, for next structures
- Guidelines for use of control-of-flow structures
Working with Forms and Controls
- Using the toolbox
- Working with User Form properties, events and methods, controls and properties
- Understanding controls, using Label; text box; Command button; option button; combo box and
- frame controls
- Setting the tab order
- Populating a control
- Adding code to controls
- Launching a form in code
Debugging Code
- Understanding errors and debugging tools
- Setting breakpoints and stepping through code
- determining the value of expressions
Handling Errors
- Understanding error handling and trapping
Share your review
Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.