|
Programming
in VBA |
an eWord company |
|
Microsoft Office courses are conducted using 2003, however these courses are suitable for users of versions 2000 and XP/2002. |
_files/image001.jpg)
|
General Course Information This 3 day program aims to provide a good understanding of programming in Visual Basic for Applications (VBA), especially as it relates to Microsoft Excel.
You will learn to Ø Use the macro recorder to record Excel operations Ø Use the recorder to create working applications in Excel Ø Create user defined functions Ø Work with the Visual Basic Editor Ø Work with VBA tools such as the immediate window and the Object Browser Ø Work with procedures and the coding of them Ø Use variables effectively in VBA programming Ø Work with Excel Object model Ø Work with conventional programming techniques (ie decision making, branching and looping) Ø Create custom forms in Excel Ø Customise the menu system to run VBA procedures Ø Work with automatic startup and automatic shut down procedures
What skills you need Those attending this course should have a sound working knowledge of Microsoft Excel, including formulas, ranges, functions, working with multiple workbooks and printing to the level covered in the Electus Excel Advanced course.
Previous programming experience at least at a basic level is desirable.
Electus training Electus is a South Australian company with 20 years of experience in training. Trainers and facilitators at Electus are chosen for their expertise, practical and broad experience in their field and a relaxed and friendly manner.
Training includes Each participant receives a training reference manual/workbook and supplementary training materials. Refreshments and lunch are provided. |
|
Duration 3 days 9:00am-4:30pm
Who needs to come Anyone who needs to develop skills in using Visual Basic for Applications in Excel.
Regular venue 37 Angas Street Adelaide SA (near Victoria Square)
How to book Contact
Electus by
Course dates Visit www.electus.com.au for the latest course schedule or ring us on (08) 8221 5517.
|
Course Content
|
Recorded Macros · Macro Recorder Overview · Recording a Simple Macro · Running a Recorded Macro · Relative Recording · Running a Relative Recording · Viewing the Module · Modifying a Recorded Macro Recorder Workshop · Creating an Application · Examining the Data · Recording a Summation Macro · Recording an Averaging Macro · Recording the Minimum and Maximum Macros · Recording the Divisional Macro · Testing Macros · Creating Objects to Run Macros · Assigning a Macro to an Object User Defined Functions · Creating and Using a User Defined Function · Creating Another Function · Passing Multiple Arguments · Modifying a Function · Creating a Function Library The VBA Editor · Overview of the VBA Editor · Opening and Closing the Editor · Working with the Project Explorer · Working with the Properties Window · Using the Work Area · Working with a Code Module · Running Procedures from the Editor · Setting Break Points in the Editor · Stepping through a Procedure |
Understanding VBA · Overview of VBA · Using the Immediate Window · Working with Object Collections · Setting Property Values · Working with Worksheets · Using the Object Browser · Programming with the Object Browser Procedures · Procedures Overview · Creating a Command Procedure · Making Sense of IntelliSense · Using the Edit Toolbar · Commenting Statements · Indenting Text · Bookmarking in Procedures Using Variables · Variables · Creating and Using Variables · Implicit and Explicit Declarations · The Scope of Variables · Procedure Level Scoping · Module Level Scoping · Public Scoping of Variables · Passing Variables by Reference · Passing Variables by Value · Avoiding Variant Data Types · Using Arrays Using Excel Objects · Overview of the Excel Object Model · Splitting the Screen · Using Workbook Objects · Using Worksheet Objects · Using Range Objects · Using Objects in a Procedure · |
Programming Techniques · Understanding Programming Conventions · Communicating with a User · Prompting for User Input · Using the Input Method · Using IF to make Decisions · Testing for Multiple Conditions · Looping a Fixed Number of Times · Looping a Specified or Unknown Number of Times Custom Forms · Custom Forms Overview · Creating a Custom Form · Changing the Form Properties · Adding Text Boxes · Moving Controls · Adding Label Controls · Changing Text Box Control Properties · Changing Label Control Properties · Adding a Combo Box · Adding Option Buttons · Adding Command Buttons · Running/Initialising a Form · Closing the Form · Updating the List · Creating Error Checking Procedures · Running a Form from a Procedure Custom Menus · Creating a New Menu · Creating a Cascade Menu · Adding Menu Commands · Assigning Macros to Menu Commands · Removing a Menu Auto Start Macros · Automatic Execution of Macros · Programming Automatic Events · Running Automatic Procedures · Automatically Starting the Workbook |