Scheduled Dates (sort by: location | date) |
Request availability or book by selecting a date: Central London
City
England
Prices exclude VAT.
Why do prices vary? Using CourseMonster, you search the schedules of over 100 training companies in one convenient location. Choose the city, date and price that best suits you.
Have questions or need a better city/date? Ask now.
On-site/international quote? Ask now.
|
Course Overview This training course takes you through Visual Basic for Applications in Excel from recording macros through to advanced form design. On the way you will learn how to write object-oriented programs and how to create loops and implement error-handling. Audience Those who require the fundamental skills to create useful and powerful VB applications. Skills Gained - After the course delegates will be able to:
- Work with Command and Function procedures
- Understand Variables
- Work with Objects
- Create User Forms
- Set options within Excel
- Observe event handling codes
- Debug Code
Examinations A list or description of examinations which will, or can be, taken following completion this course. Prerequisites A good working knowledge of Excel will maximise the benefits derived from this course. Course Outline - Introduction to the VBA environment
- Command & Function procedures
- Using Variables
- Operators
- Objects
- Collections
- Properties
- Methods
- Design Making Code If...then
- If...then...else
- Select case
- Code that repeat's
- Do...loop
- For...next
- Using exit in Loops
- Using VBA to display information
- Reading and setting Excel's options Application objects
- Worksheet objects
- Range objects
- Using Forms
- Controls
- Event handling code
- User defined menus & toolbars
- Add in Applications
- Breakpoints and watches
- The Immediate Window
How to make a booking for the MVBExc course
|
