Add-ins
Add additional functionality to your applications.
Arrays
Use arrays to work with a set of values of the same data type.
Best Practices
Lots of suggestions to make your code easier to maintain.
Class Modules
Use class modules to create your own custom objects.
Code Snippets
Access hundreds of useful VBA code snippets for common tasks.
Collections
Represent groups of items in an ordered list.
Controls
Add controls to userforms to collect or display information.
Databases
Connect to different data sources and retrieve information.
Data Types
A data-type defines what type of data a variable will contain.
Dates & Times
Format and manipulate all your dates and times.
Debugging
Identify and fix run-time errors after they occur.
Enumerations
A complete list of all the built-in VBA enumerations.
Error Handling
Find and prevent errors occurring in your code.
Events
Run code automatically when a specific event occurs.
Files & Directories
Access and change files on your local file system.
Functions
A complete list of all the built-in VBA functions with examples.
Macros
Record your steps and analyse the generated code.
MsgBox
Display messages to the user or ask the user to input information.
Numbers
Format and manipulate all your numbers.
Options
Understand all the different options in the Visual Basic Editor.
References
Access and use external libraries saved locally.
Ribbon
Customize the ribbon interface of your applications.
Shortcut Keys
A complete list of all the keys in the Visual Basic Editor.
SQL
The standard data access language for relational databases.
Strings & Characters
Format and manipulate all your text and characters.
Subroutines
Organise your code into small reusable blocks.
Syntax
Understand how the keywords and operators are put together.
Userforms
Create custom windows and dialog boxes for your users.
Variables
Store values in memory while your code runs.
Visual Basic Editor
An application integrated into every office application.
Web Interaction
Retrieve data from web pages and web services.
XML
A markup language and file format for saving data.
Add-ins
Add additional functionality to your applications.
Arrays
Use arrays to work with a set of values of the same data type.
Best Practices
Lots of suggestions to make your code easier to maintain.
Class Modules
Use class modules to create your own custom objects.
Code Snippets
Access hundreds of useful VBA code snippets for common tasks.
Collections
Represent groups of items in an ordered list.
Controls
Add controls to userforms to collect or display information.
Databases
Connect to different data sources and retrieve information.
Data Types
A data-type defines what type of data a variable will contain.
Dates & Times
Format and manipulate all your dates and times.
Debugging
Identify and fix run-time errors after they occur.
Enumerations
A complete list of all the built-in VBA enumerations.
Error Handling
Find and prevent errors occurring in your code.
Events
Run code automatically when a specific event occurs.
Files & Directories
Access and change files on your local file system.
Functions
A complete list of all the built-in VBA functions with examples.
Macros
Record your steps and analyse the generated code.
MsgBox
Display messages to the user or ask the user to input information.
Numbers
Format and manipulate all your numbers.
Options
Understand all the different options in the Visual Basic Editor.
References
Access and use external libraries saved locally.
Ribbon
Customize the ribbon interface of your applications.
Shortcut Keys
A complete list of all the keys in the Visual Basic Editor.
SQL
The standard data access language for relational databases.
Strings & Characters
Format and manipulate all your text and characters.
Subroutines
Organise your code into small reusable blocks.
Syntax
Understand how the keywords and operators are put together.
Userforms
Create custom windows and dialog boxes for your users.
Variables
Store values in memory while your code runs.
Visual Basic Editor
An application integrated into every office application.
Web Interaction
Retrieve data from web pages and web services.
XML
A markup language and file format for saving data.