Writing Word Macros, Second Edition

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 ...