Alphabetical A - M
ABS | Returns the absolute value of a number (Variant). |
AND | The logical 'AND' operator (Boolean). |
APPACTIVATE | Activates an application or window currently running on Windows. |
ARRAY | Returns an array containing the given values (Variant). |
ASC | Returns the ASCII / ANSI number for the first character in a text string (Integer). |
ASCW | Returns the Unicode number for the first character in a text string (Integer) |
ATN | Returns the arc-tangent of a number in radians (Double). |
BEEP | Produces a single beep noise. |
CALL | Transfers control to a subroutine or function. |
CALLBYNAME | Returns, sets or executes a method or property of an object (Variant). |
CBOOL | Returns the expression converted to a boolean data type (Boolean). |
CBYTE | Returns the expression converted to a byte data type (Byte). |
CCUR | Returns the expression converted to a currency data type (Currency). |
CDATE | Returns the expression converted to a date data type (Date). |
CDBL | Returns the expression converted to a double data type (Double). |
CDEC | Returns the expression converted to a decimal variant-subtype (Variant). |
CHDIR | Defines the current default directory. |
CHDRIVE | Defines the current default drive. |
CHOOSE | Returns the value from a list of values based on an index number (Variant). |
CHR | Returns the character with the corresponding ASCII / ANSI number (Variant / String). |
CHRW | Returns the character with the corresponding Unicode number (Variant / String) |
CINT | Returns the expression converted to an integer data type (Integer). |
CLNG | Returns the expression converted to a long data type (Long). |
CLNGLNG | Returns the expression converted to a longlong (64 bit platform) data type. |
CLNGPTR | Returns the expression converted to a longptr data type. |
CLOSE | Closes a text file or CSV file. |
COMMAND | Returns the argument portion of the command line used to launch the application (Variant). |
COS | Returns the cosine of an angle in radians (Double). |
CREATEOBJECT | Returns a reference after creating a new ActiveX or OLE object (Variant). |
CSNG | Returns the expression converted to a single data type (Single). |
CSTR | Returns the expression converted to a string data type (String). |
CURDIR | Returns the current path of a given drive (Variant / String). |
CVAR | Returns the expression converted to a variant data type (Variant). |
CVDATE | Returns the expression converted to a variant date subtype (Variant). |
CVERR | Returns a specific type of error (Variant). |
DATE - Function | Returns the current system date (Variant / Date). |
DATE - Statement | Defines the current system date. |
DATEADD | Returns the date with a specified time interval added (Date). |
DATEDIFF | Returns the number of a given time interval between two specified dates (Long). |
DATEPART | Returns the specified part of a given date (Variant / Integer). |
DATESERIAL | Returns the date given a year, month and day (Date). |
DATEVALUE | Returns the date given a string representation of a date (Date). |
DAY | Returns the day from a given date (Integer). |
DDB | Returns the depreciation of an asset in a single period (double or higher declining balance method) (Double). |
DELETESETTING | Removes (or deletes) a key or section from the registry. |
DIR | Returns the name of a file or directory matching a pattern or attribute (Variant / String). |
DOEVENTS | Pauses execution to let the system process other events. |
ENVIRON | Returns information about the current operating system environment (String). |
EOF | Returns the value indicating if the end of a file has been reached (Boolean). |
EQV | The logical equivalence operator. |
ERASE | Reinitialises the elements of an array. |
ERROR - Function | Returns the error message corresponding to a given error number (String). |
ERROR - Statement | (Err.Raise) Generates an error. |
EXP | Returns the base of natural logarithm raised to a power (Double). |
FILEATTR | Returns the file mode of the specified open file (Long). |
FILECOPY | Copies a file from one directory to another. |
FILEDATETIME | Returns the date and time when a file was created or last modified (Date). |
FILELEN | Returns the length of a file in bytes (Long). |
FILTER | Returns an array containing a subset of values that contain a substring (Variant). |
FIX | Returns the integer portion of a number (data type). |
FORMAT | Returns the text string of a number or date in a particular format (Variant / String). |
FORMATCURRENCY | Returns the expression formatted as a currency value (String). |
FORMATDATETIME | Returns the expression formatted as a date or time (String). |
FORMATNUMBER | Returns the expression formatted as a number (String). |
FORMATPERCENT | Returns the expression formatted as a percentage (String). |
FREEFILE | Returns the next valid free file number (Integer). |
FV | Returns the future value of a series of equal cash flows at regular intervals (Double). |
GET | Reads data from a text file into a record. |
GETALLSETTINGS | Returns the list of key settings and their values from the registry (Variant). |
GETATTR | Returns the attributes of a given file or directory (Integer). |
GETOBJECT | Returns the reference to an object provided by an ActiveX component. |
GETSETTING | Reads from the registry and returns the value or key from the registry (String). |
GOTO | Transfers control to the subroutine indicated by the line label. |
HEX | Returns the number converted to hexadecimal (Variant / String). |
HOUR | Returns the hour from a given time (Integer). |
IIF | Returns one of two parts, depending on the evaluation of an expression. |
IMESTATUS | Returns the current Input Method Editor mode of Microsoft Windows (Integer). |
IMP | The logical implication from two values (Variant). |
IMPLEMENTS | Specifies an interface or class that can be implemented in a class module. |
INPUT - Function | Reads a number of characters from a file (String). |
INPUT - Statement | Reads data from a file and assigns the data to a list of variables (Long). |
INPUTBOX | Displays a dialog box allowing the user to enter some information (String). |
INSTR | Returns the position of a substring within a larger string (Long). |
INSTRREV | Returns the position of a substring within a larger string, starting at the end (Long). |
INT | Returns the integer portion of a number (data type). |
IPMT | Returns the interest paid in a given period in a series of equal cash flows at regular intervals (Double). |
IRR | Returns the interest rate for a series of unequal cash flows at regular intervals (implicit reinvestment rate) (Double). |
IS | Compares two object reference variables. |
ISARRAY | Returns the value True or False depending if the expression is an array (Boolean). |
ISDATE | Returns the value True or False depending if the expression is a date (Boolean). |
ISEMPTY | Returns the value True or False depending if the Variant variable has been initialised (Boolean). |
ISERROR | Returns the value True or False depending if the expression is an error (Boolean). |
ISMISSING | Returns the value True or False depending if the optional argument has been passed to a procedure (Boolean). |
ISNULL | Returns the value True or False depending if the expression contains no data (Boolean). |
ISNUMERIC | Returns the value True or False depending if the expression is a number (Boolean). |
ISOBJECT | Returns the value True or False depending if the identifier represents an object (Boolean). |
JOIN | Returns a text string containing all the elements in an array (String). |
KILL | Deletes an existing file. |
LBOUND | Returns the lower limit in a given dimension of an array (Long). |
LCASE | Returns the text string with all characters converted to lowercase (Variant / String). |
LEFT | Returns a substring from the left of a string (Variant / String). |
LEN | Returns the number of characters in a string (Long). |
LET | Computes a value and assigns it to a new variable. |
LIKE | The pattern matching operator. |
LINE INPUT | Reads a single line from a file opened with Sequential access (String). |
LOAD | Loads an object but doesn't display it. |
LOADPICTURE | Loads a picture from a file into a Picture or Image control (IPictureDisp). |
LOC | Returns the current read/write position within an open file (Long). |
LOCK | Locks access to parts of a file for other processes. |
LOF | Returns the length or size of an open file, in bytes (Long). |
LOG | Returns the natural logarithm of a number (Double). |
LSET | Left aligns a string within a string variable. |
LTRIM | Returns the text string without leading spaces (Variant / String). |
MACID | Converts a four character constant to a value that can be used by Dir, Kill, Shell and AppActivate. |
MID - Function | Returns a substring from the middle, left or right of a string (Variant / String). |
MID - Statement | Replaces a specified number of characters with characters from another string. |
MINUTE | Returns the minutes from a given time (Integer). |
MIRR | Returns the interest rate for a series of unequal cash flows at regular intervals (explicit reinvestment rate) (Double). |
MKDIR | Creates a new directory. |
MOD | Returns the remainder after division operator (Integer). |
MONTH | Returns the month from a given date (Integer). |
MONTHNAME | Returns the month as a string (String). |
MSGBOX | Displays a dialog box displaying a message to the user (Integer). |
ABS Returns the absolute value of a number (Variant). |
AND The logical 'AND' operator (Boolean). |
APPACTIVATE Activates an application or window currently running on Windows. |
ARRAY Returns an array containing the given values (Variant). |
ASC Returns the ASCII / ANSI number for the first character in a text string (Integer). |
ASCW Returns the Unicode number for the first character in a text string (Integer) |
ATN Returns the arc-tangent of a number in radians (Double). |
BEEP Produces a single beep noise. |
CALL Transfers control to a subroutine or function. |
CALLBYNAME Returns, sets or executes a method or property of an object (Variant). |
CBOOL Returns the expression converted to a boolean data type (Boolean). |
CBYTE Returns the expression converted to a byte data type (Byte). |
CCUR Returns the expression converted to a currency data type (Currency). |
CDATE Returns the expression converted to a date data type (Date). |
CDBL Returns the expression converted to a double data type (Double). |
CDEC Returns the expression converted to a decimal variant-subtype (Variant). |
CHDIR Defines the current default directory. |
CHDRIVE Defines the current default drive. |
CHOOSE Returns the value from a list of values based on an index number (Variant). |
CHR Returns the character with the corresponding ASCII / ANSI number (Variant / String). |
CHRW Returns the character with the corresponding Unicode number (Variant / String) |
CINT Returns the expression converted to an integer data type (Integer). |
CLNG Returns the expression converted to a long data type (Long). |
CLNGLNG Returns the expression converted to a longlong (64 bit platform) data type. |
CLNGPTR Returns the expression converted to a longptr data type. |
CLOSE Closes a text file or CSV file. |
COMMAND Returns the argument portion of the command line used to launch the application (Variant). |
COS Returns the cosine of an angle in radians (Double). |
CREATEOBJECT Returns a reference after creating a new ActiveX or OLE object (Variant). |
CSNG Returns the expression converted to a single data type (Single). |
CSTR Returns the expression converted to a string data type (String). |
CURDIR Returns the current path of a given drive (Variant / String). |
CVAR Returns the expression converted to a variant data type (Variant). |
CVDATE Returns the expression converted to a variant date subtype (Variant). |
CVERR Returns a specific type of error (Variant). |
DATE - Function Returns the current system date (Variant / Date). |
DATE - Statement Defines the current system date. |
DATEADD Returns the date with a specified time interval added (Date). |
DATEDIFF Returns the number of a given time interval between two specified dates (Long). |
DATEPART Returns the specified part of a given date (Variant / Integer). |
DATESERIAL Returns the date given a year, month and day (Date). |
DATEVALUE Returns the date given a string representation of a date (Date). |
DAY Returns the day from a given date (Integer). |
DDB Returns the depreciation of an asset in a single period (double or higher declining balance method) (Double). |
DELETESETTING Removes (or deletes) a key or section from the registry. |
DIR Returns the name of a file or directory matching a pattern or attribute (Variant / String). |
DOEVENTS Pauses execution to let the system process other events. |
ENVIRON Returns information about the current operating system environment (String). |
EOF Returns the value indicating if the end of a file has been reached (Boolean). |
EQV The logical equivalence operator. |
ERASE Reinitialises the elements of an array. |
ERROR - Function Returns the error message corresponding to a given error number (String). |
ERROR - Statement (Err.Raise) Generates an error. |
EXP Returns the base of natural logarithm raised to a power (Double). |
FILEATTR Returns the file mode of the specified open file (Long). |
FILECOPY Copies a file from one directory to another. |
FILEDATETIME Returns the date and time when a file was created or last modified (Date). |
FILELEN Returns the length of a file in bytes (Long). |
FILTER Returns an array containing a subset of values that contain a substring (Variant). |
FIX Returns the integer portion of a number (data type). |
FORMAT Returns the text string of a number or date in a particular format (Variant / String). |
FORMATCURRENCY Returns the expression formatted as a currency value (String). |
FORMATDATETIME Returns the expression formatted as a date or time (String). |
FORMATNUMBER Returns the expression formatted as a number (String). |
FORMATPERCENT Returns the expression formatted as a percentage (String). |
FREEFILE Returns the next valid free file number (Integer). |
FV Returns the future value of a series of equal cash flows at regular intervals (Double). |
GET Reads data from a text file into a record. |
GETALLSETTINGS Returns the list of key settings and their values from the registry (Variant). |
GETATTR Returns the attributes of a given file or directory (Integer). |
GETOBJECT Returns the reference to an object provided by an ActiveX component. |
GETSETTING Reads from the registry and returns the value or key from the registry (String). |
GOTO Transfers control to the subroutine indicated by the line label. |
HEX Returns the number converted to hexadecimal (Variant / String). |
HOUR Returns the hour from a given time (Integer). |
IIF Returns one of two parts, depending on the evaluation of an expression. |
IMESTATUS Returns the current Input Method Editor mode of Microsoft Windows (Integer). |
IMP The logical implication from two values (Variant). |
IMPLEMENTS Specifies an interface or class that can be implemented in a class module. |
INPUT - Function Reads a number of characters from a file (String). |
INPUT - Statement Reads data from a file and assigns the data to a list of variables (Long). |
INPUTBOX Displays a dialog box allowing the user to enter some information (String). |
INSTR Returns the position of a substring within a larger string (Long). |
INSTRREV Returns the position of a substring within a larger string, starting at the end (Long). |
INT Returns the integer portion of a number (data type). |
IPMT Returns the interest paid in a given period in a series of equal cash flows at regular intervals (Double). |
IRR Returns the interest rate for a series of unequal cash flows at regular intervals (implicit reinvestment rate) (Double). |
IS Compares two object reference variables. |
ISARRAY Returns the value True or False depending if the expression is an array (Boolean). |
ISDATE Returns the value True or False depending if the expression is a date (Boolean). |
ISEMPTY Returns the value True or False depending if the Variant variable has been initialised (Boolean). |
ISERROR Returns the value True or False depending if the expression is an error (Boolean). |
ISMISSING Returns the value True or False depending if the optional argument has been passed to a procedure (Boolean). |
ISNULL Returns the value True or False depending if the expression contains no data (Boolean). |
ISNUMERIC Returns the value True or False depending if the expression is a number (Boolean). |
ISOBJECT Returns the value True or False depending if the identifier represents an object (Boolean). |
JOIN Returns a text string containing all the elements in an array (String). |
KILL Deletes an existing file. |
LBOUND Returns the lower limit in a given dimension of an array (Long). |
LCASE Returns the text string with all characters converted to lowercase (Variant / String). |
LEFT Returns a substring from the left of a string (Variant / String). |
LEN Returns the number of characters in a string (Long). |
LET Computes a value and assigns it to a new variable. |
LIKE The pattern matching operator. |
LINE INPUT Reads a single line from a file opened with Sequential access (String). |
LOAD Loads an object but doesn't display it. |
LOADPICTURE Loads a picture from a file into a Picture or Image control (IPictureDisp). |
LOC Returns the current read/write position within an open file (Long). |
LOCK Locks access to parts of a file for other processes. |
LOF Returns the length or size of an open file, in bytes (Long). |
LOG Returns the natural logarithm of a number (Double). |
LSET Left aligns a string within a string variable. |
LTRIM Returns the text string without leading spaces (Variant / String). |
MACID Converts a four character constant to a value that can be used by Dir, Kill, Shell and AppActivate. |
MID - Function Returns a substring from the middle, left or right of a string (Variant / String). |
MID - Statement Replaces a specified number of characters with characters from another string. |
MINUTE Returns the minutes from a given time (Integer). |
MIRR Returns the interest rate for a series of unequal cash flows at regular intervals (explicit reinvestment rate) (Double). |
MKDIR Creates a new directory. |
MOD Returns the remainder after division operator (Integer). |
MONTH Returns the month from a given date (Integer). |
MONTHNAME Returns the month as a string (String). |
MSGBOX Displays a dialog box displaying a message to the user (Integer). |
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top