VBA for Excel (Intelligent Programming with VBA Excel)

Course Description

This course aims to increase your productivity by providing the skills and knowledge to use programming VBA code in Excel 2003 effectively.

Pre-Requisites

This course is designed for participants who have a sound working knowledge of Excel 2003. Participants should have extensive experience in formulas, ranges, functions and multiple workbooks.

Outcome

At the completion of this course, participants will be able to:

• Create recorded macros in Excel
• Use the macro recorder to create a variety of macros
• Create and work with userdefined functions
• Work with the main components of the VBA Editor window
• Create command procedures
• Create and use variables
• Write code to manipulate Excel objects
• Use a range of common programming techniques
• Create a custom form complete with controls and event procedures.

---

User Reviews

Not yet rated. You will need to follow this course before you can write a review.