Microsoft Excel VBA
Course
In Leeds and London
Description
-
Type
Course
-
Location
-
Duration
2 Days
The skills and knowledge acquired in Microsoft Excel VBA Introduction are sufficient to be able to use and operate the software at an efficient level. Suitable for: Microsoft Excel VBA Introduction is designed for users who are keen to extend their understanding and knowledge of the software.
Facilities
Location
Start date
Start date
Start date
About this course
Microsoft Excel VBA Introduction assumes the delegate has completed the Excel Fundamentals, Excel Intermediate and Excel Advanced courses or has equivalent knowledge.
Reviews
Course programme
At the completion of Microsoft Excel VBA Introduction you should be able to:
· Create recorded macros in Excel
· Use the macro recorder to create a variety of macros
· Create and work with user-defined functions
· Work with the main components of the VBA Editor window
· Understand the Excel object model and use the Immediate 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
· Create code to drive a custom form
· Customise the menu system
· Create procedures that start automatically
· Debug Excel VBA
Microsoft Excel VBA