Book your place now
|
Delivery
Method:
Classroom Course
|
|
|
Dates:
|
Times:
9:00 AM - 4:30 PM
|
|
Duration:
|
2 Days
|
| |
| |
|
Location:
|
Advanced Training, Level 3, 85 Queen Street , Melbourne, VIC 3000
View map
|
| |
| |
|
Places:
|
0
|
| |
| |
| |
|
Price:
|
$ 950
(Price includes GST)
|
In this one-day VBA for Excel 2007 - Intelligent Programming Training Course participants will cover subjects such as; Visual Basic Editor, Programming basics, Control structures, Custom dialog boxes, Debugging and error handling.
At the end of this VBA for Excel 2007 - Intelligent Programming Training Course, participants will be able to:
• Use the Visual Basic for Applications (VBA) terminology and start Visual Basic Editor (VBE), save workbooks in a macro enabled file format, work with object properties and methods, attach code to events and buttons, and use the Object Browser to get information about objects.
• Use the variables of relevant data types, manipulate data by using expressions, get input from the user, declare and use variables of correct scope, declare and use procedures of correct scope, create Sub and Function procedures, and call one procedure from another.
• Use decision structures to create procedures that execute code, based on specific conditions, and use loop structures to execute specific code repeatedly.
• Add a user form to your project and add controls to the user form, handle events attached to controls in a user form, and validate the data entry in the controls.
• Identify compile-time, runtime, and logical errors in code, use the debugging tools, and write error- handling code to trap errors.
Advanced Training provides a range of computer training solutions offering flexible delivery methods, a cost effective approach, smooth implementation and an exceptional level of quality service.
Advanced Training Locations:
• Queen Street, Melbourne - Victoria
• Moore Street, Turner - Canberra
• York Street, Sydney - New South Wales
• Church Street, Parramatta - New South Wales
• Astor Terrace, Spring Hill - Brisbane, Qld
• Innovation House, Mawson Lakes - South Australia
• Patrick Street, Hobart - Tasmania
• St George's Terrace, Perth - Western Australia
If you need further information contact Startnextweek.com.au on 1300 728 102