ChDir
Dir
FileLen
MkDir
ChDrive
FileDateTime
GetAttr
SetAttr
Welcome to VBA Tips & Tricks. All VBA related information will be posted on this blog. Of late, VBA has been disregarded by many software professionals for .Net, c# and other technologies. This blog will also post articles related to them too Happy reading
Monday, September 13, 2010
Data Type Conversion Functions in VBA Functions:-
CBool
CDate
CInt
CStr
CByte
CDbl
CLng
CVar
CCur
CDec
CSng
CDate
CInt
CStr
CByte
CDbl
CLng
CVar
CCur
CDec
CSng
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
DateValue
Month
Weekday
DateAdd
Day
MonthName
WeekdayName
DateDiff
Format
Dates
Now
Year
DatePart
Hour
TimeSerial
DateSerial
Minute
TimeValue
Numeric / Mathematical Functions in VBA Functions:-
Abs
Fix
Rnd
Tan
Atn
Format
Numbers
Round
Cos
Int
Sgn
Exp
Log
Sin
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
========================
Asc
InStrRev
Replace
Trim
Chr
LCase
Right
UCase
Concatenate with &
Left
RTrim
Val
CurDir
Len
Space
Format
Strings
LTrim
Str
InStr
Mid
StrConv
Subscribe to:
Posts (Atom)