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.