Chapter 7. Built-in Functions and Statements

In this chapter:

  • The MsgBox Function

  • The InputBox Function

  • VBA String Functions

  • Miscellaneous Functions and Statements

VBA has a large number of built-in functions and subroutines. We will take a look at a few of the more commonly used ones (at least for programming Word VBA) in this chapter and the next. The VBA functions are:

Abs

DateSerial

Int

Oct

Array

DateValue

Ipmt

Partition

Asc

Day

IRR

Pmt

AscB

DDB

IsArray

PPmt

AscW

Dir

IsDate

PV

Atn

DoEvents

IsEmpty

QBColor

Cbool

Environ

IsError

Rate

Cbyte

EOF

IsMissing

RGB

Ccur

Error

IsNull

Right

Cdate

Exp

IsNumeric

RightB

CDbl

FileAttr

IsObject

Rnd

Cdec

FileDateTime

Lbound

RTrim

Choose

FileLen

Lcase

Second

Chr

Fix

Left

Seek

ChrB

Format

LeftB

Sgn

ChrW

FreeFile

Len

Shell

Cint

FV

LenB

Sin

CLng

GetAllSettings

LoadPicture

SLN

Command

GetAttr

Loc

Space

Cos

GetAutoServerSettings

LOF

Spc

CreateObject

GetObject

Log

Sqr

CSng

GetSetting

Ltrim

Str

CStr

Hex

Mid

StrComp

CurDir

Hour

MidB

StrConv

Cvar

Iif

Minute

String

CVDate

IMEStatus

MIRR

Switch

CVErr

Input

Month

SYD

Date

InputB

MsgBox

Tab

DateAdd

InputBox

Now

Tan

DateDiff

InStr

Nper

Time

DatePart

InStrB

NPV

Timer

TimeSerial

TypeName

Val

Year

TimeValue

UBound

VarType

 

Trim

UCase

Weekday

 

The VBA statements are:

AppActivate

Do…Loop

Mid

Reset

Beep

End

MidB

Resume

Call

Enum

MkDir

Return

ChDir

Erase

Name

RmDir ...

Get Writing Word Macros, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.