Duration: 1 Day
Course Code: XLL5
Course Aims:
This course is aimed at people who wish to make a start at learning the Excel VBA programming language, familiarising themselves with the concepts and practice of VBA programming, and understanding and using the relevant techniques.
Course Pre-requisites:
This course is aimed at people who wish to make a start at learning the Excel VBA programming language, familiarising themselves with the concepts and practice of VBA programming, and understanding and using the relevant techniques.
Course Objectives:
On completion of this course delegates will be able to:
• Use the Macro Recorder
• Understand how VBA code is stored and how to access it using the Visual Basic Editor
• Launch the Visual Basic Editor and use it to manage module sheets and code
• Get macros to run via shortcut keys, menus and buttons
Course Content:
Introduction and Objectives
Recording Macros
• What is a macro?
• Recording a Macro
• Running a Macro
• Saving a Workbook Containing a Macro
• Opening a Workbook Containing a Macro
• Saving the Personal Macro Workbook
The Visual Basic Editor
• Launching the Visual Basic Editor
• Navigating the Visual Basic Editor
• Finding a Macro in the Visual Basic Editor
• Inserting a Module into a Workbook
• Copying a Module between Workbooks
• Renaming a Module Sheet
• Deleting a Module Sheet
Assigning Macros
• Running a Macro with Shortcut Keys
• Adding Custom Buttons to Run a Macro
• Removing Custom Buttons
• Creating and Editing a Worksheet Macro Button
Writing Procedures
• Frequently Used Excel Objects (Range, WorkSheets, WorkBooks)
• Methods and Properties
• Adding Arguments to Methods
• Selection or ActiveCell?
• The With … End With Block
• The Offset Property
• Dealing with a Runtime Error
Control Structures
• The If – Then Control Structure
• The If – Then – Else Control Structure
• Using ElseIf in a Control Structure
• The Select Case Control Structure
• Using a Do – Loop Statement
Data Variables
• What are Data Variables?
• Creating Data Variables and Assigning Values
Action planning
Review of Programme
Click Here to view Course Dates
For more information on how to book, please click here.
Many thanks,
WWP & the Euroclear Team