Key Information
Duration: 1 days
Course Learning Skills: VBA 2013
Additional Material: Download Course Slides Link
Brief
We offer three one day Excel VBA courses to cover the three levels of Basic, Intermediate and Advanced. You can, if you wish, do all three over a three day period or combine any two over a two day period.
Also, you can mix and match modules from the three levels if you would prefer to tailor a course more suited to your needs.
Attendees
This course is for experienced users of Excel who are looking to dip their toe into VBA and introduce more automation and flexibility into their spreadsheets.
Prerequisites
Ideally each delegate should already be proficient at creating and maintaining spreadsheets and be comfortable with most of Excel’s more advanced features (e.g. formulas, functions, pivot tables, charts).
Benefits
Delegates will gain an understanding of the basic principles of Excel VBA programming and be able to do the following:
- Amend a recorded macro so that it works in a variety of situations
- Create a function for their own use to supplement those already in Excel
- Create a procedure to automate a series of basic manual tasks
Basics
- Overview of the VBA environment
- How to record and modify a macro
- Use of relative and absolute addressing
- Introduction to modules, procedures and functions
- Use of comments in a macro
- How to Step through and test a macro
- Overview of objects, properties and methods
- Overview of the Excel object hierarchy
Working with a range of cells
- Overview of the Range object
- Use of the Selection property
- Retrieval of count of cells in a selection
- Use the Offset method and property
- Retrieval of cell values and formulae
- Maintenance of cell values
- Use of column and row properties
- Use of property combinations
Working with workbooks and worksheets
- Overview of the Workbook object
- Overview of the Worksheet object
- Use of the Activate and Add methods
Visual Basic components
- Use of variables and data types
- Use of IF and CASE statements
- Use of DO and FOR loops
Running Macros
- Use of MSGBOX and INPUTBOX dialogue objects
- Assigning macros to objects
- Basic forms and buttons
Creating Procedures & Functions
- Use of parameters and arguments
- Key differences between procedures and functions
- Use of user defined functions in spreadsheets
Do a short survey to tell us what you think about training?
Click here to take the survey, it’ll only take a few minutes!