Monday, September 13, 2010

File/Directory Functions in VBA Functions:-

ChDir
Dir
FileLen
MkDir
ChDrive
FileDateTime
GetAttr
SetAttr

Financial Functions in VBA Functions:-

DDb
Mirr
PPmt
Syd
FV
NPer
PV
IPmt
Npv
Rate
Irr
Pmt
SLn

Data Type Conversion Functions in VBA Functions:-

CBool
CDate
CInt
CStr
CByte
CDbl
CLng
CVar
CCur
CDec
CSng

Lookup / Reference Functions in VBA Functions:-

Choose
Switch

Date & Time Functions in VBA Functions:-

Date
DateValue
Month
Weekday
DateAdd
Day
MonthName
WeekdayName
DateDiff
Format
Dates
Now
Year
DatePart
Hour
TimeSerial
DateSerial
Minute
TimeValue

Information Functions in VBA Functions:-

IsDate
IsError
IsNull
IsNumeric

Numeric / Mathematical Functions in VBA Functions:-

Abs
Fix
Rnd
Tan
Atn
Format
Numbers
Round
Cos
Int
Sgn
Exp
Log
Sin

String Functions in VBA Functions:-

View an Listing in VBA:-
========================

Asc
InStrRev
Replace
Trim
Chr
LCase
Right
UCase
Concatenate with &
Left
RTrim
Val
CurDir
Len
Space
Format
Strings
LTrim
Str
InStr
Mid
StrConv