Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
546 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Search our website
We also send out useful tips in a monthly email newsletter ...
Here are the chapters included in this course manual (we use exactly the same manuals for our classroom and online Visual Basic for Applications courses).
Click here to download a sample of the first two chapters of this Advanced VBA macros manual, or review how to license our courseware.
Section | Title |
---|---|
1.1 | VBA Reference |
Section | Title |
---|---|
2.1 | Object Oriented Programming |
2.2 | Objects |
2.3 | Collections |
2.4 | Methods |
2.5 | Properties |
2.6 | Getting Help in VBA |
Section | Title |
---|---|
3.1 | Looping Through Collections |
3.2 | Looping Over Excel Worksheets, Charts and Sheets |
3.3 | Looping Over the Excel Workbooks Collection |
3.4 | Looping Over a Collection of Excel Range Objects |
3.5 | Nesting For Each Loops |
3.6 | Looping Over Collections in Word |
3.7 | Looping Over Collections in PowerPoint |
3.8 | Looping Over Collections in Access |
3.9 | Looping Over Collections in Outlook |
Section | Title |
---|---|
4.1 | Referencing Object Libraries |
4.2 | An Example for Word |
4.3 | An Example for PowerPoint |
4.4 | An Example for Outlook |
4.5 | Controlling Applications without References |
4.6 | Referencing Other VBA Projects |
Section | Title |
---|---|
5.1 | Working with Files and Folders |
5.2 | Basic File and Folder Techniques |
5.3 | Looping Over Files and Folders |
5.4 | Working with Text Files |
5.5 | Using VBA’s FileSystem Methods |
Section | Title |
---|---|
6.1 | Working with File Dialogs |
6.2 | Customising File Dialogs |
6.3 | Picking Files and Folders |
Section | Title |
---|---|
7.1 | What are Class Modules? |
7.2 | Designing a Class |
7.3 | Creating a Class |
7.4 | Creating Basic Properties |
7.5 | Creating Full Properties |
7.6 | Creating Methods |
7.7 | Class Module Events |
7.8 | Sharing Class Modules |
Section | Title |
---|---|
8.1 | What are Collections? |
8.2 | Untyped Collections |
8.3 | Typed Collections |
8.4 | Dictionaries |
Section | Title |
---|---|
9.1 | ActiveX Data Objects |
9.2 | Connecting to an External Database |
9.3 | Creating Connections in Access |
9.4 | ADO Recordsets |
9.5 | Moving in a Recordset |
9.6 | Finding and Filtering Records |
9.7 | Modifying Data |
9.8 | ADO Commands |
9.9 | Using DAO |
Section | Title |
---|---|
10.1 | Overview of Arrays |
10.2 | Declaring Arrays |
10.3 | Populating Arrays |
10.4 | Reading from Arrays |
10.5 | Dynamic Arrays |
10.6 | Arrays in Excel |
Section | Title |
---|---|
11.1 | Modular Code |
11.2 | Breaking a Procedure into Parts |
11.3 | Procedures and Parameters |
11.4 | Passing Arguments ByRef and ByVal |
11.5 | Functions vs. Subroutines |
11.6 | Debugging Modular Code |
Section | Title |
---|---|
12.1 | Working with Constants |
12.2 | Enumerations |
Section | Title |
---|---|
13.1 | Recursive Procedures |
13.2 | Organisational Hierarchies |
Section | Title |
---|---|
14.1 | Debugging Code |
14.2 | Running Code |
14.3 | Breakpoints |
14.4 | The Immediate Window |
14.5 | The Locals Window |
14.6 | The Watch Window |
14.7 | The Call Stack |
14.8 | Useful Keyboard Shortcuts |
Section | Title |
---|---|
15.1 | Run-Time Errors in VBA |
15.2 | Error Handling in VBA |
15.3 | Using the On Error Statement |
15.4 | Creating a Custom Error Handler |
15.5 | Resuming After an Error |
15.6 | The Err Object |
15.7 | Raising Custom Errors |
15.8 | Errors in Multiple Procedures |
Section | Title |
---|---|
16.1 | Introduction to Shapes |
16.2 | Referring to Shapes |
16.3 | Shape Size and Position |
16.4 | Adding Shapes |
16.5 | Formatting Shapes |
16.6 | Shape Adjustments |
16.7 | Adding Text to AutoShapes |
16.8 | Formatting Text in a Shape |
16.9 | Connectors and Lines |
If you book a place on one of our courses you will automatically get access to the relevant courseware manual online, and also have the option to receive a paper copy of it.
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.