Alphabetical A - M

ABSReturns the absolute value of a number (Variant).
ANDThe logical 'AND' operator (Boolean).
APPACTIVATEActivates an application or window currently running on Windows.
ARRAYReturns an array containing the given values (Variant).
ASCReturns the ASCII / ANSI number for the first character in a text string (Integer).
ASCWReturns the Unicode number for the first character in a text string (Integer)
ATNReturns the arc-tangent of a number in radians (Double).
BEEPProduces a single beep noise.
CALLTransfers control to a subroutine or function.
CALLBYNAMEReturns, sets or executes a method or property of an object (Variant).
CBOOLReturns the expression converted to a boolean data type (Boolean).
CBYTEReturns the expression converted to a byte data type (Byte).
CCURReturns the expression converted to a currency data type (Currency).
CDATEReturns the expression converted to a date data type (Date).
CDBLReturns the expression converted to a double data type (Double).
CDECReturns the expression converted to a decimal variant-subtype (Variant).
CHDIRDefines the current default directory.
CHDRIVEDefines the current default drive.
CHOOSEReturns the value from a list of values based on an index number (Variant).
CHRReturns the character with the corresponding ASCII / ANSI number (Variant / String).
CHRWReturns the character with the corresponding Unicode number (Variant / String)
CINTReturns the expression converted to an integer data type (Integer).
CLNGReturns the expression converted to a long data type (Long).
CLNGLNGReturns the expression converted to a longlong (64 bit platform) data type.
CLNGPTRReturns the expression converted to a longptr data type.
CLOSECloses a text file or CSV file.
COMMANDReturns the argument portion of the command line used to launch the application (Variant).
COSReturns the cosine of an angle in radians (Double).
CREATEOBJECTReturns a reference after creating a new ActiveX or OLE object (Variant).
CSNGReturns the expression converted to a single data type (Single).
CSTRReturns the expression converted to a string data type (String).
CURDIRReturns the current path of a given drive (Variant / String).
CVARReturns the expression converted to a variant data type (Variant).
CVDATEReturns the expression converted to a variant date subtype (Variant).
CVERRReturns a specific type of error (Variant).
DATE - FunctionReturns the current system date (Variant / Date).
DATE - StatementDefines the current system date.
DATEADDReturns the date with a specified time interval added (Date).
DATEDIFFReturns the number of a given time interval between two specified dates (Long).
DATEPARTReturns the specified part of a given date (Variant / Integer).
DATESERIALReturns the date given a year, month and day (Date).
DATEVALUEReturns the date given a string representation of a date (Date).
DAYReturns the day from a given date (Integer).
DDBReturns the depreciation of an asset in a single period (double or higher declining balance method) (Double).
DELETESETTINGRemoves (or deletes) a key or section from the registry.
DIRReturns the name of a file or directory matching a pattern or attribute (Variant / String).
DOEVENTSPauses execution to let the system process other events.
ENVIRONReturns information about the current operating system environment (String).
EOFReturns the value indicating if the end of a file has been reached (Boolean).
EQVThe logical equivalence operator.
ERASEReinitialises the elements of an array.
ERROR - FunctionReturns the error message corresponding to a given error number (String).
ERROR - Statement(Err.Raise) Generates an error.
EXPReturns the base of natural logarithm raised to a power (Double).
FILEATTRReturns the file mode of the specified open file (Long).
FILECOPYCopies a file from one directory to another.
FILEDATETIMEReturns the date and time when a file was created or last modified (Date).
FILELENReturns the length of a file in bytes (Long).
FILTERReturns an array containing a subset of values that contain a substring (Variant).
FIXReturns the integer portion of a number (data type).
FORMATReturns the text string of a number or date in a particular format (Variant / String).
FORMATCURRENCYReturns the expression formatted as a currency value (String).
FORMATDATETIMEReturns the expression formatted as a date or time (String).
FORMATNUMBERReturns the expression formatted as a number (String).
FORMATPERCENTReturns the expression formatted as a percentage (String).
FREEFILEReturns the next valid free file number (Integer).
FVReturns the future value of a series of equal cash flows at regular intervals (Double).
GETReads data from a text file into a record.
GETALLSETTINGSReturns the list of key settings and their values from the registry (Variant).
GETATTRReturns the attributes of a given file or directory (Integer).
GETOBJECTReturns the reference to an object provided by an ActiveX component.
GETSETTINGReads from the registry and returns the value or key from the registry (String).
GOTOTransfers control to the subroutine indicated by the line label.
HEXReturns the number converted to hexadecimal (Variant / String).
HOURReturns the hour from a given time (Integer).
IIFReturns one of two parts, depending on the evaluation of an expression.
IMESTATUSReturns the current Input Method Editor mode of Microsoft Windows (Integer).
IMPThe logical implication from two values (Variant).
IMPLEMENTSSpecifies an interface or class that can be implemented in a class module.
INPUT - FunctionReads a number of characters from a file (String).
INPUT - StatementReads data from a file and assigns the data to a list of variables (Long).
INPUTBOXDisplays a dialog box allowing the user to enter some information (String).
INSTRReturns the position of a substring within a larger string (Long).
INSTRREVReturns the position of a substring within a larger string, starting at the end (Long).
INTReturns the integer portion of a number (data type).
IPMTReturns the interest paid in a given period in a series of equal cash flows at regular intervals (Double).
IRRReturns the interest rate for a series of unequal cash flows at regular intervals (implicit reinvestment rate) (Double).
ISCompares two object reference variables.
ISARRAYReturns the value True or False depending if the expression is an array (Boolean).
ISDATEReturns the value True or False depending if the expression is a date (Boolean).
ISEMPTYReturns the value True or False depending if the Variant variable has been initialised (Boolean).
ISERRORReturns the value True or False depending if the expression is an error (Boolean).
ISMISSINGReturns the value True or False depending if the optional argument has been passed to a procedure (Boolean).
ISNULLReturns the value True or False depending if the expression contains no data (Boolean).
ISNUMERICReturns the value True or False depending if the expression is a number (Boolean).
ISOBJECTReturns the value True or False depending if the identifier represents an object (Boolean).
JOINReturns a text string containing all the elements in an array (String).
KILLDeletes an existing file.
LBOUNDReturns the lower limit in a given dimension of an array (Long).
LCASEReturns the text string with all characters converted to lowercase (Variant / String).
LEFTReturns a substring from the left of a string (Variant / String).
LENReturns the number of characters in a string (Long).
LETComputes a value and assigns it to a new variable.
LIKEThe pattern matching operator.
LINE INPUTReads a single line from a file opened with Sequential access (String).
LOADLoads an object but doesn't display it.
LOADPICTURELoads a picture from a file into a Picture or Image control (IPictureDisp).
LOCReturns the current read/write position within an open file (Long).
LOCKLocks access to parts of a file for other processes.
LOFReturns the length or size of an open file, in bytes (Long).
LOGReturns the natural logarithm of a number (Double).
LSETLeft aligns a string within a string variable.
LTRIMReturns the text string without leading spaces (Variant / String).
MACIDConverts a four character constant to a value that can be used by Dir, Kill, Shell and AppActivate.
MID - FunctionReturns a substring from the middle, left or right of a string (Variant / String).
MID - StatementReplaces a specified number of characters with characters from another string.
MINUTEReturns the minutes from a given time (Integer).
MIRRReturns the interest rate for a series of unequal cash flows at regular intervals (explicit reinvestment rate) (Double).
MKDIRCreates a new directory.
MODReturns the remainder after division operator (Integer).
MONTHReturns the month from a given date (Integer).
MONTHNAMEReturns the month as a string (String).
MSGBOXDisplays 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