• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

IV. Visual Basic for Applications > 12. Built-in Functions and Statements

Chapter 12. Built-in Functions and Statements

VBA has a large number of built-in functions and statements. For possible reference, Table 12-1 shows the VBA functions, and Table 12-2 shows the statements. We will take a look at a few of the more commonly used functions and statements in this chapter and the next.

Table 12-1. VBA functions

Abs

CreateObject

Error

InputB

Len

PPmt

StrComp

Array

CSng

Exp

InputBox

LenB

PV

StrConv

Asc

CStr

FileAttr

InStr

LoadPicture

QBColor

String

AscB

CurDir

FileDateTime

InStrB

Loc

Rate

Switch

AscW

Cvar

FileLen

Int

LOF

RGB

SYD

Atn

CVDate

Fix

Ipmt

Log

Right

Tab

CBool

CVErr

Format

IRR

Ltrim

RightB

Tan

CByte

Date

FreeFile

IsArray

Mid

Rnd

Time

CCur

DateAdd

FV

IsDate

MidB

RTrim


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint