homepage
sitemap
About us
Download
Learning center
Friday, 13 December 2024
You are here:
Sitemap
Sitemap
Sitemap
About us
Download
VBA functions
Array functions
Add columns to array
Add entry to array
Array size
Array unique values
Convert array to String
Convert to 2D array
Convert to string array
Count array items
Count dimensions
Create array of strings
Filter array
Get array column
Get array headers as dictionary
Is defined array
Is dynamic array
Is in array
Join arrays
Paste data into worksheet
Remove array columns
Remove empty rows
Sort array 1D
Sort array 2D
Transpose array
Text functions
Add leading zeros
Check if empty string
Check if is in range
Check if text contains any given substring
Check if text contains substring
Column header
Compare strings
Compare strings end
Compare strings start
Compare two strings
Convert to string
Count occurrences
Cut characters
Ends with ...
Format string
Is digit
Is non-empty string
Only digits
Print to textfile
Remove spaces
Split excluding empties
Start with upper case
Starts with ...
Substring
Datetime functions
Count working days difference
Days in month
Months difference
Weeks difference
System functions
Check if file exists
Create folder
Create UUID
Delete file
Delete folder
Get desktop path
Get file extension
Get file name
Get parent folder
Is folder writeable
Is subfolders adding allowed
Is textfile writeable
Select files
Unique file path
Unique folder name
Database functions
Get DB table fields
Get recordset as array
User form functions
Count selected items on list
Get selected items on list
Excel functions
Create new Excel workbook
Find header row
First non-empty column
First non-empty row
Get array column
Is book valid
Is file open
Is range valid
Is sheet valid
Is the same sheet
Last non-empty column
Last non-empty row
Legal sheet name
Next visible column
Next visible row
Open Excel workbook
Unique sheet name
Collection functions
Dictionary to array
Get dictionary keys
Get dictionary values
Join collections
Join dictionaries
Object functions
Developer functions
Get VB project
Learning center
VBA tutorial - Basic
01 - Introduction to VBA
02 - Interaction with Excel
03 - Variables
04 - Data types
05 - Procedures
06 - Functions
07 - Built-in functions
08 - Interaction with users
09 - Conditional statements
10 - For loop
11 - Select Case
12 - Do … Loop
13 - Introduction to VBA arrays
14 - Properties of VBA arrays