VBA's Most Useful Built-in Functions

After a 3 days gap, I'm here with a new article. My friends tried Excel Macros and given me more tasks. And this post is for them.

Most of the Excel guys will never check for the existing functions of VBA, they simply create functions by their selves. But that one actually a complex and time consuming task. But for some functions there are built-in functions available in VBA. So going forward gain your valuable time by using built-in functions :) :)

There are 1000's of built-in functions but I'm just posting the important one's.

For complete details on a particular function, type the function name into a VBA module, move the cursor anywhere in the text, and press F1(Help)
find below the main built in functions .....

Function	Description
Abs	Returns a number's absolute value
Array	Returns a variant containing an array
Asc	Converts the first character of a string to its ASCII value
Atn	Returns the arctangent of a number
Choose	Returns a value from a list of items
Chr	Converts an ANSI value to a string
Cos	Returns a number's cosine
CurDir	Returns the current path
Date	Returns the current system date
DateAdd	Returns a date to which a specified time interval has been
	added — for example, one month from a particular date
DateDiff	Returns an integer showing the number of specified time intervals between two dates, for example the number of months between now and your birthday
DatePart	Returns an integer containing the specified part of a given
	date — for example, a date's day of the year
DateSerial	Converts a date to a serial number
DateValue	Converts a string to a date
Day	Returns the day of the month from a date value
Dir	Returns the name of a file or directory that matches a pattern
Erl	Returns the line number that caused an error
Err	Returns the error number of an error condition
Error	Returns the error message that corresponds to an error number
Exp	Returns the base of the natural logarithm (e) raised to a power
FileLen	Returns the number of bytes in a file
Fix	Returns a number's integer portion
Format	Displays an expression in a particular format
GetSetting	Returns a value from the Windows registry
Hex	Converts from decimal to hexadecimal
Hour	Returns the hours portion of a time
InputBox	Displays a box to prompt a user for input
InStr	Returns the position of a string within another string
Int	Returns the integer portion of a number
IPmt	Returns the interest payment for an annuity or loan
IsArray	Returns True if a variable is an array
IsDate	Returns True if an expression is a date
IsEmpty	Returns True if a variable has not been initialized
IsError	Returns True if an expression is an error value
IsMissing	Returns True if an optional argument was not passed to a procedure
IsNull	Returns True if an expression contains no valid data
IsNumeric	Returns True if an expression can be evaluated as a number
IsObject	Returns True if an expression references an OLE Automation object
LBound	Returns the smallest subscript for a dimension of an array
LCase	Returns a string converted to lowercase
Left	Returns a specified number of characters from the left of a string
Len	Returns the number of characters in a string
Log	Returns the natural logarithm of a number to base e
LTrim	Returns a copy of a string, with any leading spaces removed
Mid	Returns a specified number of characters from a string
Minute	Returns the minutes portion of a time value
Month	Returns the month from a date value
MsgBox	Displays a message box and (optionally) returns a value
Now	Returns the current system date and time
RGB	Returns a numeric RGB value representing a color
Right	Returns a specified number of characters from the right of a string
Rnd	Returns a random number between 0 and 1
RTrim	Returns a copy of a string, with any trailing spaces removed
Second	Returns the seconds portion of a time value
Sgn	Returns an integer that indicates a number's sign
Shell	Runs an executable program
Sin	Returns a number's sine
Space	Returns a string with a specified number of spaces
Sqr	Returns a number's square root
Str	Returns a string representation of a number
StrComp	Returns a value indicating the result of a string comparison
String	Returns a repeating character or string
Tan	Returns a number's tangent
Time	Returns the current system time
Timer	Returns the number of seconds since midnight
TimeSerial	Returns the time for a specified hour, minute, and second
TimeValue	Converts a string to a time serial number
Trim	Returns a string without leading or trailing spaces
TypeName	Returns a string that describes a variable's data type
UBound	Returns the largest available subscript for an array's dimension
UCase	Converts a string to uppercase
Val	Returns the numbers contained in a string
VarType	Returns a value indicating a variable's subtype
Weekday	Returns a number representing a day of the week
Year	Returns the year from a date value

Welcome your comments and suggestions...Good Night :)