Complete List

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 ANSI 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 ANSI number (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.
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 (String).
CVARReturns the expression converted to a variant data type (Variant).
CVDATEReturns the expression converted to a date variant-subtype (Variant).
CVERRReturns a specific type of error (Variant).
DATE - FunctionReturns the current system date (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 (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 over a period of time (Double).
DELETESETTINGRemoves (or deletes) a key or section from the registry.
DIRReturns the name of a file or directory matching a pattern or attribute (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 bitwise comparison 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 (Double).
FORMATReturns the text string of a number or date in a particular format (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 (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 - FunctionReturns the open stream of an Input or Binary file (String).
INPUT - StatementReads data from an open sequential field and assigns the data to a variable (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 number rounded down to the nearest integer (Double).
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 contains a number (Boolean).
ISOBJECTReturns the value True or False depending if the identifier represents an object (Boolean).
JOINReturns the text string containing the elements in an array (String).
KILLDeletes an existing file.
LBOUNDReturns the smallest subscript in a given dimension of an array (Long).
LCASEReturns the text string with all characters converted to lowercase (String).
LEFTReturns a number of characters from the left of a string (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 an Open sequential file and assigns it to a 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 (String).
MACIDConverts a four character constant to a value that can be used by Dir, Kill, Shell and AppActivate.
MID - FunctionReturns the text string which is a substring of a larger string (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).
NAMERenames an existing file or directory.
NOTThe logical 'NOT' operator (Boolean).
NOWReturns the current system date and time (Date).
NPERReturns the number of periods for an investment (Double).
NPVReturns the present value of a series of unequal cash flows at regular intervals (Double).
OBJPTRReturns a LongPtr on a 64 bit version and a Long on a 32 bit version.
OCTReturns the number converted to octal (Variant).
OPENOpens a text file or CSV file.
ORThe logical 'OR' operator (Boolean).
PARTITIONReturns a string indicating which particular range it falls into (String).
PMTReturns the amount of principal and interest paid in a given period in a series of equal cash flows at regular intervals (Double).
PPMTReturns the amount of principal paid in a given period in a series of equal cash flows at regular intervals (Double).
PRINTWrites display-formatted data to a sequential file.
PUTWrites data from a record into a text file.
PVReturns the present value of an annuity (Double).
QBCOLORReturns the RGB colour corresponding to the specified colour number (Long).
RAISEEVENTFires an event declared at module level within a class, form or document.
RANDOMIZEInitialises the random number generator.
RATEReturns the interest rate for a series of equal cash flows at regular intervals (Double).
REDIMInitialises and resizes a dynamic array.
REMSpecifies a single line of comments.
REPLACEReturns the text string with a number of characters replaced (String).
RESETCloses all files open with the Open statement.
RGBReturns the number representing an RGB colour value (Long).
RIGHTReturns a number of characters from the right of a string (String).
RMDIRRemoves an existing directory.
RNDReturns a random number between 0 and 1 (Single).
ROUNDReturns a number rounded to a given number of decimal places (Double).
RSETRight aligns a string within a string variable.
RTRIMReturns the text string without trailing spaces (String).
SAVEPICTURESaves a graphic image from an objects Picture or Image property to a file.
SAVESETTINGWrites to the registry and saves a section or key in the registry.
SECONDReturns the seconds from a given time (Integer).
SEEK - FunctionReturns the current read/write position within a file opened using the Open statement (Long).
SEEK - StatementRepositions where the next operation in a file will occur.
SENDKEYSSends keystrokes to an application.
SETAssigns an object reference to an object variable.
SETATTRDefines the attributes of a file or directory.
SGNReturns the sign of a number (Integer).
SHELLReturns the program's task id from running an executable programs (Double).
SINReturns the sine of an angle in radians (Double).
SLNReturns the straight-line depreciation of an asset over a single period of time (Double).
SPACEReturns the specified number of spaces (String).
SPCInserts a specified number (n) of spaces when writing or displaying text.
SPLITReturns the array containing a specified number of substrings (Variant).
SQRReturns the square root of a number (Double).
STOPSuspends execution.
STRReturns the text string of a number (String).
STRCOMPReturns the result of a string comparison (Integer).
STRCONVReturns the text string converted to a specific case or type (String).
STRINGReturns a repeating character of a given length (String).
STRPTRReturns a LongPtr on a 64 bit version and a Long on a 32 bit version.
STRREVERSEReturns the text string with the characters reversed (String).
SWITCHReturns a value based on expressions (Variant).
SYDReturns the sum-of-years' digits depreciation of an asset (Double).
TABUsed with the Print # statement or the Print method to position output.
TANReturns the tangent of an angle (Double).
TIME - FunctionReturns the current system time (Date).
TIME - StatementDefines the current system time.
TIMERReturns the number of seconds elapsed since midnight (Single).
TIMESERIALReturns the time for a specific hour, minute and second (Date).
TIMEVALUEReturns the time given a string representation of a time (Date).
TRIMReturns the text string removing leading and trailing spaces (String).
TYPENAMEReturns the data type of the variable as a string (String).
TYPEOFReturns the object data type.
UBOUNDReturns the largest subscript in a given dimension of an array (Long).
UCASEReturns the text string with all the characters converted to uppercase (String).
UNLOADRemoves an object from memory.
UNLOCKControls access to a file.
VALReturns the numbers contained in a string as a numeric value of the appropriate data type (Double).
VARPTRReturns a LongPtr on a 64 bit version and a Long on a 32 bit version.
VARTYPEReturns the number indicating the data type of a variable (Integer).
WEEKDAYReturns the number representing the day of the week for a given date (Integer).
WEEKDAYNAMEReturns the day of the week as a string (String).
WIDTHAssigns an output line width (characters) for the open file.
WRITEWrites data to a sequential file.
XORThe bitwise exclusion operator.
YEARReturns the year from a date (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 ANSI 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 ANSI number (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.
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 (String).
CVAR
Returns the expression converted to a variant data type (Variant).
CVDATE
Returns the expression converted to a date variant-subtype (Variant).
CVERR
Returns a specific type of error (Variant).
DATE - Function
Returns the current system date (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 (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 over a period of time (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 (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 bitwise comparison 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 (Double).
FORMAT
Returns the text string of a number or date in a particular format (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 (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
Returns the open stream of an Input or Binary file (String).
INPUT - Statement
Reads data from an open sequential field and assigns the data to a variable (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 number rounded down to the nearest integer (Double).
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 contains a number (Boolean).
ISOBJECT
Returns the value True or False depending if the identifier represents an object (Boolean).
JOIN
Returns the text string containing the elements in an array (String).
KILL
Deletes an existing file.
LBOUND
Returns the smallest subscript in a given dimension of an array (Long).
LCASE
Returns the text string with all characters converted to lowercase (String).
LEFT
Returns a number of characters from the left of a string (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 an Open sequential file and assigns it to a 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 (String).
MACID
Converts a four character constant to a value that can be used by Dir, Kill, Shell and AppActivate.
MID - Function
Returns the text string which is a substring of a larger string (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).
NAME
Renames an existing file or directory.
NOT
The logical 'NOT' operator (Boolean).
NOW
Returns the current system date and time (Date).
NPER
Returns the number of periods for an investment (Double).
NPV
Returns the present value of a series of unequal cash flows at regular intervals (Double).
OBJPTR
Returns a LongPtr on a 64 bit version and a Long on a 32 bit version.
OCT
Returns the number converted to octal (Variant).
OPEN
Opens a text file or CSV file.
OR
The logical 'OR' operator (Boolean).
PARTITION
Returns a string indicating which particular range it falls into (String).
PMT
Returns the amount of principal and interest paid in a given period in a series of equal cash flows at regular intervals (Double).
PPMT
Returns the amount of principal paid in a given period in a series of equal cash flows at regular intervals (Double).
PRINT
Writes display-formatted data to a sequential file.
PUT
Writes data from a record into a text file.
PV
Returns the present value of an annuity (Double).
QBCOLOR
Returns the RGB colour corresponding to the specified colour number (Long).
RAISEEVENT
Fires an event declared at module level within a class, form or document.
RANDOMIZE
Initialises the random number generator.
RATE
Returns the interest rate for a series of equal cash flows at regular intervals (Double).
REDIM
Initialises and resizes a dynamic array.
REM
Specifies a single line of comments.
REPLACE
Returns the text string with a number of characters replaced (String).
RESET
Closes all files open with the Open statement.
RGB
Returns the number representing an RGB colour value (Long).
RIGHT
Returns a number of characters from the right of a string (String).
RMDIR
Removes an existing directory.
RND
Returns a random number between 0 and 1 (Single).
ROUND
Returns a number rounded to a given number of decimal places (Double).
RSET
Right aligns a string within a string variable.
RTRIM
Returns the text string without trailing spaces (String).
SAVEPICTURE
Saves a graphic image from an objects Picture or Image property to a file.
SAVESETTING
Writes to the registry and saves a section or key in the registry.
SECOND
Returns the seconds from a given time (Integer).
SEEK - Function
Returns the current read/write position within a file opened using the Open statement (Long).
SEEK - Statement
Repositions where the next operation in a file will occur.
SENDKEYS
Sends keystrokes to an application.
SET
Assigns an object reference to an object variable.
SETATTR
Defines the attributes of a file or directory.
SGN
Returns the sign of a number (Integer).
SHELL
Returns the program's task id from running an executable programs (Double).
SIN
Returns the sine of an angle in radians (Double).
SLN
Returns the straight-line depreciation of an asset over a single period of time (Double).
SPACE
Returns the specified number of spaces (String).
SPC
Inserts a specified number (n) of spaces when writing or displaying text.
SPLIT
Returns the array containing a specified number of substrings (Variant).
SQR
Returns the square root of a number (Double).
STOP
Suspends execution.
STR
Returns the text string of a number (String).
STRCOMP
Returns the result of a string comparison (Integer).
STRCONV
Returns the text string converted to a specific case or type (String).
STRING
Returns a repeating character of a given length (String).
STRPTR
Returns a LongPtr on a 64 bit version and a Long on a 32 bit version.
STRREVERSE
Returns the text string with the characters reversed (String).
SWITCH
Returns a value based on expressions (Variant).
SYD
Returns the sum-of-years' digits depreciation of an asset (Double).
TAB
Used with the Print # statement or the Print method to position output.
TAN
Returns the tangent of an angle (Double).
TIME - Function
Returns the current system time (Date).
TIME - Statement
Defines the current system time.
TIMER
Returns the number of seconds elapsed since midnight (Single).
TIMESERIAL
Returns the time for a specific hour, minute and second (Date).
TIMEVALUE
Returns the time given a string representation of a time (Date).
TRIM
Returns the text string removing leading and trailing spaces (String).
TYPENAME
Returns the data type of the variable as a string (String).
TYPEOF
Returns the object data type.
UBOUND
Returns the largest subscript in a given dimension of an array (Long).
UCASE
Returns the text string with all the characters converted to uppercase (String).
UNLOAD
Removes an object from memory.
UNLOCK
Controls access to a file.
VAL
Returns the numbers contained in a string as a numeric value of the appropriate data type (Double).
VARPTR
Returns a LongPtr on a 64 bit version and a Long on a 32 bit version.
VARTYPE
Returns the number indicating the data type of a variable (Integer).
WEEKDAY
Returns the number representing the day of the week for a given date (Integer).
WEEKDAYNAME
Returns the day of the week as a string (String).
WIDTH
Assigns an output line width (characters) for the open file.
WRITE
Writes data to a sequential file.
XOR
The bitwise exclusion operator.
YEAR
Returns the year from a date (Integer).

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top