If there are tasks and processes around data stored in Excel you want to automate, then this course is ideal.
For many people this is their first experience of programming, so there are no prerequisites in that direction. However, you need to be an experienced user of Excel and ideally have previously used the recording process to create basic macros.
Download the full course profile: Visual Basic for Excel
Introduction
- What is a Macro?
- Recording & Running a Macro
- Relative References
Assigning Macros to Buttons and Objects
- Assigning a Macro to a Button or a Drawn Object on a Sheet
- Assigning a Macro to a Button on a Toolbar
- Customising a Toolbar
- Creating a Toolbar
- Button Image Editor
- Changing a Button’s Screen Tip
Editing Macros
- Visual Basic Editor
- Project Explorer
- Procedures, Inserting Comments
- Printing a Visual Basic Module
The Range Object
- Cells & Range Method, Flexible Ranges
- Virtual Worksheets, Range Contents
Workbooks and Sheets
- Activating a Workbook & Worksheet
Objects, Properties & Methods
- Controlling Objects with their Properties
- Performing Actions with Methods
- Performing Multiple Actions on an Object
Variables and Constants
- Variables, Data Types & Constants
Control Structures
- Conditional & Looping Control Structures
- Non-Structured Statements
- Sub Procedures
Controls Dialogue Boxes and Forms
- Built-In & Predefined Dialogue Boxes
- Custom, Worksheet & User Defined Forms
- Adding Form Controls
- Form Control Properties
- Control & Dialogue Box Events
- Displaying & Dismissing a User Form
Storing Information
Toolbars & Display
- About Toolbars & Menus
- Customised Menus
- Display
Debugging & Error trapping
- Errors, Break Mode: Instant Watch
- Stepping & Error Handling
Worksheet & Workbook Events
- Worksheet Object Events
- Workbook Object Events
Function Procedures
Appendix A - Naming Conventions
- User Form Controls
- Memory Variables
The course runs from 9:30am through to 4:30pm.
You will learn in a relaxed environment with a small group of people. A specialist tutor will guide and encourage you through all the learning necessary to develop your skills and questions are always welcome.
Included with your course
We provide the following with online and training centre delivered courses.
- Course notes
- Certificate of attendance
- 90 days post course support
Online Delivery
A link to the online training platform will be sent before the course, simply click the link and follow the instructions.
- See Virtual / Remote training information for more details
- Contact us if you'd like to test the platform before the morning of the course
- You can be located anywhere in the world with an internet connection and your computer
Our Training Centres
For training courses run at one of our training centres we include.
- Free onsite parking
- Lunch and refreshments
- Notepad, pen and Polos
Our Norwich on-site parking (NR3 1UB) is free and situated 5 minutes walk along the river to our training centre at St James Mill. If you arrive by train it is about 20 minutes on the Riverside walk or a short taxi ride to get to us. View full directions for Norwich and all our other venues.