Macros and Visual Basic in Excel
Course Code:DPZ112
Course Type:Short-course
Qualification: There is no associated qualification; however delegates receive a Central Sussex College Attendance certificate on completion.
Duration: Full Day (6 hours)
Date/Venue/Cost:
08 March 2012, Horsham Training Centre, £155.00
02 May 2012, Horsham Training Centre, £155.00
14 August 2012, Horsham Training Centre, £155.00
Suitable For: This course is ideal for delegates wishing explore the more sophisticated features of the Microsoft Office applications.
Entry By: Direct Entry
Entry Requirements:
Delegates should have a good working knowledge of Excel, preferably to advanced level.
Course Content:
This course introduces delegates to the concept of writing their own Visual Basic code within the Microsoft Office applications, with the emphasis on Excel. Topics covered include:
- The Syntax
- Message Boxes
- Input boxes
- Variables
- While and Wend
- If
- Case
- Arrays
- Combo Boxes
- Movement within Spreadsheets
- Feeding Data into Spreadsheets with Code
- Code Buttons
