Function Navigation:

Note: (WS) = Worksheet function, (VBA) = Visual Basic for Applications function

MS Excel: VBA Functions - Category

String Functions

ASC (VBA)
CHR (VBA)
Concatenate with & (WS, VBA)
CURDIR (VBA)
FORMAT Strings (VBA)
INSTR (VBA)
INSTRREV (VBA)

LCASE (VBA)
LEFT (WS, VBA)
LEN (WS, VBA)
LTRIM (VBA)
MID (WS, VBA)
REPLACE (VBA)
RIGHT (WS, VBA)

RTRIM (VBA)
SPACE (VBA)
STR (VBA)
STRCONV (VBA)
TRIM (WS, VBA)
UCASE (VBA)
VAL (VBA)

Numeric / Mathematical Functions

ABS (WS, VBA)
ATN (VBA)
COS (WS, VBA)
EXP (WS, VBA)
FIX (VBA)

FORMAT Numbers (VBA)
INT (WS, VBA)
LOG (WS, VBA)
RND (VBA)
ROUND (VBA)

SGN (VBA)
SIN (WS, VBA)
TAN (WS, VBA)

Logical Functions

CASE (VBA)
IF-THEN-ELSE (VBA)

Information Functions

ISDATE (VBA)
ISERROR (WS, VBA)

ISNULL (VBA)
ISNUMERIC (VBA)

Date & Time Functions

DATE (VBA)
DATEADD (VBA)
DATEDIFF (VBA)
DATEPART (VBA)
DATESERIAL (VBA)
DATEVALUE (WS, VBA)

DAY (WS, VBA)
FORMAT Dates (VBA)
HOUR (WS, VBA)
MINUTE (WS, VBA)
MONTH (WS, VBA)
MONTHNAME (VBA)

NOW (WS, VBA)
TIMESERIAL (VBA)
TIMEVALUE (WS, VBA)
WEEKDAY (WS, VBA)
WEEKDAYNAME (VBA)
YEAR (WS, VBA)

Lookup / Reference Functions

CHOOSE (WS, VBA)
SWITCH (WS)

Data Type Conversion Functions

CBOOL (VBA)
CBYTE (VBA)
CCUR (VBA)
CDATE (VBA)

CDBL (VBA)
CDEC (VBA)
CINT (VBA)
CLNG (VBA)

CSNG (VBA)
CSTR (VBA)
CVAR (VBA)

Financial Functions

DDB (WS, VBA)
FV (WS, VBA)
IPMT (WS, VBA)
IRR (WS, VBA)
MIRR (WS, VBA)

NPER (WS, VBA)
NPV (WS, VBA)
PMT (WS, VBA)
PPMT (WS, VBA)
PV (WS, VBA)

RATE (WS, VBA)
SLN (WS, VBA)
SYD (WS, VBA)

File/Directory Functions

CHDIR (VBA)
CHDRIVE (VBA)
CURDIR (VBA)

DIR (VBA)
FILEDATETIME (VBA)
FILELEN (VBA)

GETATTR (VBA)
MKDIR (VBA)
SETATTR (VBA)