Alphabetical Listing of VBA Functions:

Alphabetical Listing of VBA Functions:
 
 Abs Exp Now 
 Asc FileDateTime NPer 
 Atn FileLen Npv 
 Case Fix Pmt 
 CBool Format Dates PPmt 
 CByte Format Numbers PV 
 CCur Format Strings Rate 
 CDate FV Replace 
 CDbl GetAttr Right 
 CDec Hour Rnd 
 ChDir IF-THEN-ELSE Round 
 ChDrive InStr RTrim 
 Choose InStrRev SetAttr 
 Chr Int Sgn 
 CInt IPmt Sin 
 CLng Irr SLn 
 Concatenate with & IsDate Space 
 Cos IsError Str 
 CSng IsNull StrConv 
 CStr IsNumeric Switch 
 CurDir LCase Syd 
 CVar Left Tan 
 Date Len TimeSerial 
 DateAdd Log TimeValue 
 DateDiff LTrim Trim 
 DatePart Mid UCase 
 DateSerial Minute Val 
 DateValue Mirr Weekday 
 Day MkDir WeekdayName 
 DDb Month Year 
 Dir MonthName   

******************************************************************
Excel Topics: VBA Functions (By Category)

--------------------------------------------------------------------------------

String Functions:

Asc InStrRev Replace Trim
Chr LCase Right UCase
Concatenate with & Left RTrim Val
CurDir Len Space
Format Strings LTrim Str
InStr Mid StrConv

Numeric / Mathematical Functions:

Abs Fix Rnd Tan
Atn Format Numbers Round
Cos Int Sgn
Exp Log Sin

Logical Functions:

Case IF-THEN-ELSE

Information Functions:

IsDate IsError IsNull IsNumeric

Date & Time Functions:

Date DateValue Month Weekday
DateAdd Day MonthName WeekdayName
DateDiff Format Dates Now Year
DatePart Hour TimeSerial
DateSerial Minute TimeValue

Lookup / Reference Functions:

Choose
Switch

Data Type Conversion Functions:

CBool CDate CInt CStr
CByte CDbl CLng CVar
CCur CDec CSng

Financial Functions:

DDb Mirr PPmt Syd
FV NPer PV
IPmt Npv Rate
Irr Pmt SLn

File/Directory Functions:

ChDir Dir FileLen MkDir
ChDrive FileDateTime GetAttr SetAttr