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.

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Updated: 08 October 2024 08 October 2024