In this section you can find lots of useful VBA code you can use in your own projects. All the code samples presented on this website have been tested properly. However, if you realize that any code sample downloaded from this website doesn't work properly, we will be grateful for any information about it.

Every VBA function or subroutine is described in its comment part, above the code itself. Usages examples of every function are given below the code.

Functions and subroutines are divided into several sections:

• Arrays - functions and subroutines operating on arrays
• Text - functions and subroutines operating on Strings
• Date and time - functions and subroutines operating on date and time
• System - functions and subroutines operating on files, folders and other system resources
• User forms - functions and subroutines operating on user-forms and their components
• Excel - functions and subroutines operating on Excel objects, like workbooks, worksheets or cells
• Collection - functions and subroutines operating on collections
• Object - functions and subroutines operating on objects
• Developer - functions and subroutines operating on VBA editor and its components