Functions, without guesswork.

Function Abs(ByVal Number As Variant) As Variant

Function Array(ParamArray Value As Variant) As Variant

Function Asc(ByVal String As String) As Integer

Function AscW(ByVal String As String) As Integer

Function Atn(ByVal Number As Double) As Double

Function CBool(ByVal Expression As Variant) As Boolean

Function CByte(ByVal Expression As Variant) As Byte

Function CCur(ByVal Expression As Variant) As Currency

Function CDate(ByVal Expression As Variant) As Date

Function CDbl(ByVal Expression As Variant) As Double

Function CDec(ByVal Expression As Variant) As Decimal

Function Choose(ByVal Index As Long, ParamArray Choice As Variant) As Variant

Function Chr(ByVal Code As Integer) As String

Function ChrW(ByVal Code As Integer) As String

Function CInt(ByVal Expression As Variant) As Integer

Function CLng(ByVal Expression As Variant) As Long

Function CLngLng(ByVal Expression As Variant) As LongLong

Function Cos(ByVal Number As Double) As Double

Function CSng(ByVal Expression As Variant) As Single

Function CStr(ByVal Expression As Variant) As String

Function CVErr(ByVal ErrorCode As Integer) As Variant

Function Date() As Date

Function DateAdd(ByVal Interval As String, ByVal Number As Double, ByVal Date As Date) As Date

Function DateDiff(ByVal Interval As String, ByVal Date1 As Date, ByVal Date2 As Date) As Long

Function DatePart(ByVal Interval As String, ByVal Date As Date) As Long

Function DateSerial(ByVal Year As Long, ByVal Month As Long, ByVal Day As Long) As Date

Function Day(ByVal Date As Date) As Integer

Function Exp(ByVal Number As Double) As Double

Function Filter(ByVal SourceArray As Variant, ByVal Match As String, Optional ByVal Include As Boolean = True, Optional ByVal Compare As Long = 0) As Variant

Function Fix(ByVal Number As Double) As Double

Function Format(ByVal Expression As Variant, ByVal Format As String) As String

Function Hex(ByVal Number As Long) As String

Function Hour(ByVal Date As Date) As Integer

Function IIf(ByVal Expression As Boolean, ByVal TruePart As Variant, ByVal FalsePart As Variant) As Variant

Function InputBox(ByVal Prompt As String, Optional ByVal Title As String = App.Name, Optional ByVal Default As String = "") As String

Function InStr(ByVal String As String, ByVal Search As String) As Long

Function InStr(ByVal Start As Long, ByVal String As String, ByVal Search As String) As Long

Function InStrRev(ByVal String As String, ByVal Search As String, Optional ByVal Start As Long = -1) As Long

Function Int(ByVal Number As Double) As Double

Function IsArray(ByVal Expression As Variant) As Boolean

Function IsDate(ByVal Expression As Variant) As Boolean

Function IsEmpty(ByVal Expression As Variant) As Boolean

Function IsError(ByVal Expression As Variant) As Boolean

Function IsMissing(ByVal Expression As Variant) As Boolean

Function IsNull(ByVal Expression As Variant) As Boolean

Function IsNumeric(ByVal Expression As Variant) As Boolean

Function IsObject(ByVal Expression As Variant) As Boolean

Function Join(ByVal SourceArray As Variant, Optional ByVal Delimiter As String = " ") As String

Function LBound(ByVal Array As Variant, Optional ByVal Dimension As Long = 1) As Long

Function LCase(ByVal String As String) As String

Function LCase$(ByVal String As String) As String

Function Left(ByVal String As String, ByVal Length As Long) As String

Function Left$(ByVal String As String, ByVal Length As Long) As String

Function Len(ByVal Expression As String) As Long

Function Log(ByVal Number As Double) As Double

Function LTrim(ByVal String As String) As String

Function LTrim$(ByVal String As String) As String

Function Mid(ByVal String As String, ByVal Start As Long, Optional ByVal Length As Long) As String

Function Mid$(ByVal String As String, ByVal Start As Long, Optional ByVal Length As Long) As String

Function Minute(ByVal Date As Date) As Integer

Function Month(ByVal Date As Date) As Integer

Function MonthName(ByVal Month As Long, Optional ByVal Abbreviate As Boolean = False) As String

Function MsgBox(ByVal Prompt As String, Optional ByVal Buttons As Long = vbOKOnly, Optional ByVal Title As String = App.Name) As Integer

Function Now() As Date

Function Oct(ByVal Number As Long) As String

Function QBColor(ByVal Color As Integer) As String

Sub Randomize(Optional ByVal Seed As Long)

Function Replace(ByVal Expression As String, ByVal Find As String, ByVal Replace As String) As String

Function RGB(ByVal Red As Integer, ByVal Green As Integer, ByVal Blue As Integer) As String

Function Right(ByVal String As String, ByVal Length As Long) As String

Function Right$(ByVal String As String, ByVal Length As Long) As String

Function Rnd(Optional ByVal Number As Double = 1) As Double

Function Round(ByVal Number As Double, Optional ByVal NumDigits As Long = 0) As Double

Function RTrim(ByVal String As String) As String

Function RTrim$(ByVal String As String) As String

Function Second(ByVal Date As Date) As Integer

Function Sgn(ByVal Number As Double) As Integer

Function Sin(ByVal Number As Double) As Double

Function Space(ByVal Number As Long) As String

Function Space$(ByVal Number As Long) As String

Function Split(ByVal Expression As String, Optional ByVal Delimiter As String = " ") As Variant

Function Sqr(ByVal Number As Double) As Double

Function Str(ByVal Number As Double) As String

Function Str$(ByVal Number As Double) As String

Function StrComp(ByVal String1 As String, ByVal String2 As String, Optional ByVal Compare As Long = 0) As Long

Function String(ByVal Number As Long, ByVal Character As String) As String

Function String$(ByVal Number As Long, ByVal Character As String) As String

Function StrReverse(ByVal String As String) As String

Function Switch(ParamArray Pair As Variant) As Variant

Function Tan(ByVal Number As Double) As Double

Function Time() As Date

Function Timer() As Single

Function TimeSerial(ByVal Hour As Long, ByVal Minute As Long, ByVal Second As Long) As Date

Function Trim(ByVal String As String) As String

Function Trim$(ByVal String As String) As String

Function TypeName(ByVal Expression As Variant) As String

Function UBound(ByVal Array As Variant, Optional ByVal Dimension As Long = 1) As Long

Function UCase(ByVal String As String) As String

Function UCase$(ByVal String As String) As String

Function Val(ByVal String As String) As Double

Function VarType(ByVal Expression As Variant) As Integer

Function Weekday(ByVal Date As Date, Optional ByVal FirstDayOfWeek As Long = 1) As Integer

Function WeekdayName(ByVal Weekday As Long, Optional ByVal Abbreviate As Boolean = False, Optional ByVal FirstDayOfWeek As Long = 1) As String

Function Year(ByVal Date As Date) As Integer