VBA Functions


ABCDEFGHIJKMNOPQRSTUVWXYZ
VBA FunctionDescriptionCategory

A

ABSReturns the absolute value of a numberMath Functions
ARRAYReturns a variant that contains an arrayArray Function
ASCConverts the first character of string to its ASCII valueText Functions
ATNReturns the arctangent of a numberMath Functions

C

CALLBYNAMEExecutes a method of an object, or sets or returns a property of an object.System Functions
CBOOLConverts a value to a booleanConvert Functions
CBYTEConverts an expression to byte data typeConvert Functions
CCURConverts a value to currencyConvert Functions
CDATEConverts a value to a dateConvert Functions
CDBLConverts a value to a doubleConvert Functions
CDECConverts an expression to decimal data typeConvert Functions
CHDIRUsed to change the current directory or folderFile Functions
CHDRIVEUsed to change the current driveFile Functions
CHOOSESelects and returns a value from a list of argumentsArray Function
CHRReturns the character based on the ASCII valueText Functions
CINTConverts an expression to integer data typeConvert Functions
CLNGConverts a value to a long integerConvert Functions
COSReturns the cosine of a numberMath Functions
CREATEOBJECTCreates and returns a reference to an ActiveX object.System Functions
CSNGConverts a value to a single-precision numberConvert Functions
CSTRConverts a value to a stringConvert Functions
CURDIRReturns the current pathFile Functions
CVARConverts a value to a variantconvert Functions
CVDATEConverts an expression to date data typeConvert Functions
CVERRProduces an Error data type for a supplied error code.System Functions

D

DATEIn Excel worksheet function - convert a supplied year, month, and day into excel date. In VBA - Return current system dateDate/Time Function
DATEADDReturns a date with a specific date interval added to itDate/Time Function
DATEDIFFCalculates the number of days, months, or years between two dates.Date/Time Function
DATEPARTReturns a specified part of a given dateDate/Time Function
DATESERIALReturns a date for a specified year, month, and dayDate/Time Function
DATEVALUEConverts a string to dateDate/Time Function
DAYReturns the day of the month of a dateDate/Time Function
DDBReturns the depreciation of an asset based on the double-declining balance methodFinancial Functions
DIRReturns the first filename that matches the pathname and attributes specifiedFile Functions
DOEVENTSYields execution so that the operating system can process other events.System Functions

E

ENVIRONReturns the value of an operating system environment variableInfo Functions
EOFReturns an Integer containing the Boolean value True when the end of a file opened for Random or sequential Input has been reached.System Functions
ERRORReturns the error message corresponding to a supplied error code.System Functions
EXPReturns e raised to the nth powerMath Functions

F

FILEATTRReturns the mode of a file that has been opened using the Open statement.File Functions
FILECOPYFileCopy Copies a fileFile Functions
FILEDATETIMEReturns the date and time of when a file was created or last modifiedFile Functions
FILELENReturns the size of a file in bytesFile Functions
FILTERReturns a subset of a supplied string array, based on supplied criteria.Array Function
FIXTruncates a number to an integer (rounding negative numbers towards zero).
Math Functions
FORMATApplies a format to an expression and returns the result as a string.
Text Functions
FORMAT DATESTakes a date expression and returns it as a formatted stringConvert Functions
FORMAT NUMBERSTakes a numeric expression and returns it as a formatted stringConvert Functions
FORMATCURRENCYReturns a number as a string, formatted as currencyConvert Functions
FORMATDATETIMEReturns a number as a string, formatted as a date and/orConvert Functions
FORMATNUMBERReturns a number as a formatted stringConvert Functions
FORMATPERCENTReturns a number as a string, formatted as a percentageConvert Functions
FREEFILEReturns an Integer representing the next file number available for use by the Open statement.System Functions
FVReturns the future value of an investmentFinancial Functions

G

GETALLSETTINGSReturns a list of key settings and their respective values (originally created with SaveSetting) from an application's entry in the Windows registry or (on the Macintosh) information in the application’s initialization file.System Functions
GETATTRReturns an integer that represents the attributes of a file, folder, or directoryFile Functions
GETOBJECTReturns a reference to an object provided by an ActiveX component.System Functions
GETSETTINGReturns a key setting value from an application's entry in the Windows registry or (on the Macintosh) information in the application’s initialization file.System Functions

H

HEXConverts from decimal to hexadecimalConvert Functions
HOURReturns the hour of a timeDate/Time Function

I

IIFReturns one of two parts, depending on the evaluation of an expression.System Functions
IMESTATUSReturns an Integer specifying the current Input Method Editor (IME) mode of Microsoft Windows; available in East Asian versions only.System Functions
INPUTReturns String containing characters from a file opened in Input or Binary mode.System Functions
INPUTBOXDisplays a dialog box prompting the user for input.I/O Function
INSTRReturn the starting position of one text string within another text. FIND is case sensitiveText Functions
INSTRREVReturns the position of a substring within a string, searching from right to left.Text Functions
INTReturns the integer portion of a numberMath Functions
IPMTReturns the interest payment for an investmentFinancial Functions
IRRReturns the internal rate of return for a series of cash flowsFinancial Functions
ISARRAYTests if a supplied variable is an array.Logical Functions
ISDATETests if a supplied expression is a date.Logical Functions
ISEMPTYReturns True if a variable has not been initializedLogical Functions
ISERRORReturn True if there is an error and false if it is no errorLogical Functions
ISMISSINGTests if an optional argument to a procedure is missing.Logical Functions
ISNULLTests if a supplied expression is Null.Logical Functions
ISNUMERICTests if a supplied value is a number, and if so, TRUE; Otherwise, FALSELogical Functions
ISOBJECTTests if a supplied variable represents an object variable.Logical Functions

J

JOINReturns a string created by joining a number of substringsArray Function

L

LBOUNDReturns the lower bound of an arrayArray Function
LCASEConverts a supplied string to lower case text.Text Functions
LEFTReturns a substring from the start of a supplied string.Text Functions
LENReturns the length of a supplied string.Text Functions
LOCReturns a Long specifying the current read/write position within an open file.System Functions
LOFReturns the number of bytes in an open text fileMath Functions
LOGReturns the natural logarithm of a numberMath Functions
LSETLset Left-aligns a string within a string variableText Functions
LTRIMRemoves leading spaces from a supplied string.Text Functions

M

MACIDUsed on the Macintosh to convert a 4-character constant to a value that may be used by Dir, Kill, Shell, and AppActivate.System Functions
MACSCRIPTExecutes an AppleScript script and returns a value returned by the script, if any.System Functions
MIDReturns a substring from the middle of a supplied string.Text Functions
MINUTEReturns the minute of a timeDate/Time Function
MIRRReturns the modified internal rate of return for a series of cash flowsFinancial Functions
MKDIRUsed to create a new folder or directoryFile Functions
MONTHReturns the month of a dateDate/Time Function
MONTHNAMEReturns a string representing the month given a number from 1 to 12Date/Time Function
MSGBOXDisplays a modal message boxI/O Function

N

NORM.DISTthe normal cumulative distribution (New in Excel 2010 - replaces the Normdist function)Math Functions
NORM.INVthe inverse of the normal cumulative distribution (New in Excel 2010 - replaces the Norminv function)Math Functions
NORM.S.DISTthe inverse of the standard normal cumulative distribution (New in Excel 2010 - replaces the Normsinv function)Math Functions
NORM.S.INVthe normal cumulative distribution (Replaced by Norm.Dist function in Excel 2010)Math Functions
NORMDISTthe inverse of the normal cumulative distribution (Replaced by Norm.Inv function in Excel 2010)Math Functions
NORMINVthe standard normal cumulative distribution (Replaced by Norm.S.Dist function in Excel 2010)Math Functions
NORMSDISTthe inverse of the standard normal cumulative distribution (Replaced by Norm.S.Inv function in Excel 2010)Math Functions
NORMSINVthe inverse of the standard normal cumulative distribution (Replaced by Norm.S.Inv function in Excel 2010)Math Functions
NOToperatorLogical Functions
NOWReturns the current system date in the format of Month, Day, Year and timeDate/Time Function
NPERReturns the number of periods for an investmentFinancial Functions
NPVReturns the net present value of an investmentFinancial Functions

O

OCTConverts from decimal to octalConvert Functions
ORReturns TRUE if any of the conditions are TRUELogical Functions

P

PARTITIONReturns a Variant (String) indicating where a number occurs within a calculated series of ranges.System Functions
PMTReturns the payment amount for a loanFinancial Functions
PPMTReturns the payment on the principal for a particular paymentFinancial Functions
PVReturns the present value of an investmentFinancial Functions

Q

QBCOLORReturns a Long representing the RGB color code corresponding to the specified color number.System Functions

R

RANDOMIZEUsed to change the seed value used by the random number generator for the RND functionMath Functions
RATEReturns the interest rate for an annuityFinancial Functions
REPLACEReplaces a substring within a supplied text string.Text Functions
RGBReturns a Long whole number representing an RGB color value.System Functions
RIGHTReturns a substring from the end of a supplied string.Text Functions
RMDIRRmDir Removes an empty directoryFile Functions
RNDReturns a random number between 0 and 1Math Functions
ROUNDRounds a number to a specific number of decimal placesMath Functions
RSETRSet Right-aligns a string within a string variableMath Functions
RTRIMRemoves trailing spaces from a supplied string.Text Functions

S

SECONDReturns the second of a timeDate/Time Function
SEEKReturns the current position in a text fileText Functions
SETATTRUsed to set the attributes of a fileFile Functions
SGNReturns the sign of a numberMath Functions
SHELLRuns an executable program and returns a Variant (Double) representing the program's task ID if successful, otherwise it returns zero.System Functions
SINReturns the sine of an angleMath Functions
SLNReturns the depreciation of an asset based on the straight-line depreciation methodFinancial Functions
SPACECreates a string consisting of a specified number of spaces.Text Functions
SPCUsed with the Print # statement or the Print method to position output.System Functions
SPLITUsed to split a string into substrings based on a delimiterText Functions
SQRReturns the square root of a numberMath Functions
STRReturns a string representation of a numberText Functions
STRCOMPCompares two strings and returns an integer representing the result of the comparison. If string1 is equal to string2, the StrComp function will return 0.
If string1 is less than string2, the StrComp function will return -1.
If string1 is greater than string2, the StrComp function will return 1.
If either string1 or string2 is NULL, the StrComp function will return NULL.
Text Functions
STRCONVConverts a string into a specified format.Text Functions
STRINGReturns a repeating character or stringText Functions
STRREVERSEReturns the characters of a string in reverse orderText Functions
SWITCHEvaluates a list of expressions and returns the corresponding value for the first expression in the list that is TRUELogical Functions
SYDReturns the depreciation of an asset based on the sum-of-years' digits depreciation methodFinancial Functions

T

TABUsed with the Print # statement or the Print method to position output.System Functions
TANReturns the tangent of an angleMath Functions
TIMEReturns the current system timeDate/Time Function
TIMERReturns the number of seconds since midnightDate/Time Function
TIMESERIALReturns the time for a specified hour, minute, and secondDate/Time Function
TIMEVALUEConverts a string to a time serial numberDate/Time Function
TRIMRemoves duplicate spaces, and spaces at the start and end of a text stringText Functions
TYPENAMEReturns a string that describes the data type of aText Functions

U

UBOUNDReturns the upper bound of an arrayArray Function
UCASEConverts all characters in a supplied text string to upper caseText Functions

V

VALConverts a text string into a numeric valueConvert Functions

W

WEEKDAYReturns a number representing a day of the weekDate/Time Function
WEEKDAYNAMEReturns a string representing the day of the week given a number from 1 to 7Date/Time Function
WHILE-WENDUsed to create a WHILE LOOPLogical Functions

Y

YEARReturns a four-digit year (a number from 1900 to 9999) given a date valueDate/Time Function