Excel Function
Excel Method (VBA)
Excel Object Property (VBA)
Excel Event (VBA)
This page lists all Excel VBA Functions that have been explained in this website.
You may also want to read:
Differences among Function, Sub, Method, Property
String Function
[table width=”750″ colwidth=”150|600″ ]
Function, Description
ASC, Return the ASCII code of the first character in the text.
CHR, Convert ASCII value to character
SPLIT, Separate a text by delimiter and store as array
INSTR, Find the position of a substring in a string
LEN, Return number of characters in a string
MID, Extract substring from a string
wCapLetter, A custom Function to capitalize first letter in a sentence
wCheckAlphabet, A custom Function to check if a text contains any alphabet
wCheckNumber, A custom Function to check if a text contains any number
wCheckOnlyAlphabet, A custom Function to check if a text contains only alphabet
wCheckOnlyNumber, A custom Function to check if a text contains only number
wCheckSymbol, A custom Function to check if a text contains any symbol
wCountSubStr, A custom Function to count substring in string
wCustomSort, A custom Function to assign numeric value to Text for custom sort
wExtractAlphabet, A custom Function to extract alphabet from text
wExtractNumber, A custom Function to extract number from text
wExtractPercent, A custom Function to extract Percent from text
wExtractSymbol, A custom Function to extract symbol from text
wExtractText, A custom Function to extract substring inside defined text (such as brackets)
wLpad, A custom Function to add leading character
wRandomHKID, A custom Function to generate random HKID (Hong Kong ID card number)
wRandomLetter, A customer Function to generate random letter a to z / A to Z / a to Z
wRandomNumber, A custom Function to generate random number by specifying lowerbound and upperbound
wRemoveBrackets, A custom Function to remove text inside brackets
wRemoveLineBreak, A custom Function to remove line break and carriage return
wRpad, A custom Function to add characters to suffix
wSumExtractNumber, A custom Function to Sum number part of text in a Range
wUniqueStr, A custom Function to remove duplicate in a text
[/table]
Numeric Function
[table width=”750″ colwidth=”150|600″ ]
Function, Description
Int, Get the integer part of a number
RND, Generate a random decimal number between larger than 0 and smaller than 1
Round, Use Banker’s rounding method to round a number
wCountColorCell, A custom Function to count number of colored Cell in a Range
wExtractNumber, A custom Function to extract number from text
wExtractPercent, A custom Function to extract Percent from text
wGroupDecimal, A custom Function to categorize/ group decimal number
wGroupInt, A custom Function to categorize/ group integer
wIsPrimeNumber, A custom Function to check if a number is prime number
wMRound, A custom Function to simulate spreadsheet MROUND Function
wSumColorCell, A custom Function to sum value of colored Cell in a Range
wSumExtractNumber, A custom Function to Sum number part of text in a Range
wRandomNumber, A custom Function to generate random number by specifying lowerbound and upperbound
wRound, A custom Function that simulates Excel worksheet Round function
[/table]
Date Function
[table width=”750″ colwidth=”150|600″ ]
Function, Description
wDateDif, A custom Function to simulate Excel worksheet Function DateDif to calculate year month day difference between two dates
wNetworkdays, A custom Function that simulates Excel worksheet Networkdays to calculate number of work days (exclude Sat and Sun) between two dates
[/table]
Lookup / Search Function
[table width=”750″ colwidth=”150|600″ ]
Function, Description
wFirstColorCell, A custom Function to look for the first colored Cell
wColLastRow, A custom Function to look for last row of specific column
wColLastRowAdd, A custom Function to look for address of last row of specific column
wColLastRowVal, A custom Function to look for value of last row of specific column
wColNm, A custom Function to convert column number to column letter
wColNum, A custom Function to convert column letter to column number
wRowLastColNum, A custom Function to look for last column number of specific row
wRowLastColNm, A custom Function to look for last column name of specific row
wRowLastColAdd, A custom Function to look for address of last column Cell of specific row
wRowLastColVal, A custom Function to look for value of last column Cell of specific row
[/table]
Boolean Function
[table width=”750″ colwidth=”150|600″ ]
Function, Description
wCheckHKID, A custom Function to check the last digit of HKID
wCheckAlphabet, A custom Function to check if a text contains any alphabet
wCheckNumber, A custom Function to check if a text contains any number
wCheckOnlyAlphabet, A custom Function to check if a text contains only alphabet
wCheckOnlyNumber, A custom Function to check if a text contains only number
wCheckSymbol, A custom Function to check if a text contains any symbol
wIfWbOpen, A custom Function to check if a workbook is opened
wsExist, A custom Function to check if a worksheet exists
wIfWbOpen, A custom Function to check if a workbook is opened
[/table]
Workbook/Worksheet Function
[table width=”750″ colwidth=”150|600″ ]
Function, Description
Dir, Retrieve the first file name that matches the criteria
wsExist, A custom Function to check if a worksheet exists
wIfWbOpen, A custom Function to check if a workbook is opened
[/table]
Financial Function
[table width=”750″ colwidth=”150|600″ ]
Function, Description
NPV, Calculate Net Present Value
[/table]
Other Function
[table width=”750″ colwidth=”150|600″ ]
Function, Description
FollowHyperlink, Open hyperlink in web browser
InputBox, Prompt box for user input
MsgBox, Prompt box to alert user or confirm action
wLinkStatusDescr, A custom Function to convert xlLinkInfoStatus from numeric value to description
wRGB, A custom Function to get RGB color of Range
[/table]