VBA練習
問題文
(ａｂｓ)
Abs
(ｃｂｙｔｅ)
CByte
(ｃｃｕｒ)
CCur
(ｃｄｂｌ)
CDbl
(ｃｄｅｃ)
CDec
(ｃｉｎｔ)
CInt
(ｃｌｎｇ)
CLng
(ｃｓｎｇ)
CSng
(ｆｉｘ)
Fix
(ｈｅｘ)
Hex
(ｉｎｔ)
Int
(ｉｓｎｕｍｅｒｉｃ)
IsNumeric
(ｏｃｔ)
Oct
(ｒｎｄ)
Rnd
(ｒｏｕｎｄ)
Round
(ｖａｌ)
Val
(ａｓｃ／ａｓｃｗ)
Asc/AscW
(ｃｈｒ／ｃｈｒｗ)
Chr/ChrW
(ｃｓｔｒ)
CStr
(ｆｏｒｍａｔ)
Format
(ｆｏｒｍａｔｃｕｒｒｅｎｃｙ)
FormatCurrency
(ｆｏｒｍａｔｄａｔｅｔｉｍｅ)
FormatDateTime
(ｆｏｒｍａｔｎｕｍｂｅｒ)
FormatNumber
(ｆｏｒｍａｔｐｅｒｃｅｎｔ)
FormatPercent
(ｉｎｓｔｒ／ｉｎｓｔｒｂ)
InStr/InStrB
(ｉｎｓｔｒｒｅｖ)
InStrRev
(ｊｏｉｎ)
Join
(ｌｃａｓｅ)
LCase
(ｌｅｆｔ／ｌｅｆｔｂ)
Left/LeftB
(ｌｅｎ／ｌｅｎｂ)
Len/LenB
(ｌｔｒｉｍ)
LTrim
(ｍｉｄ／ｍｉｄｂ)
Mid/MidB
(ｍｏｎｔｈｎａｍｅ)
MonthName
(ｐａｒｔｉｔｉｏｎ)
Partition
(ｒｅｐｌａｃｅ)
Replace
(ｒｉｇｈｔ／ｒｉｇｈｔｂ)
Right/RightB
(ｒｔｒｉｍ)
RTrim
(ｓｐａｃｅ)
Space
(ｓｔｒ)
Str
(ｓｔｒｃｏｍｐ)
StrComp
(ｓｔｒｃｏｎｖ)
StrConv
(ｓｔｒｉｎｇ)
String
(ｓｔｒｒｅｖｅｒｓｅ)
StrReverse
(ｔｒｉｍ)
Trim
(ｕｃａｓｅ)
UCase
(ｃｄａｔｅ)
CDate
(ｃｖｄａｔｅ)
CVDate
(ｄａｔｅ)
Date
(ｄａｔｅａｄｄ)
DateAdd
(ｄａｔｅｄｉｆｆ)
DateDiff
(ｄａｔｅｐａｒｔ)
DatePart
(ｄａｔｅｓｅｒｉａｌ)
DateSerial
(ｄａｔｅｖａｌｕｅ)
DateValue
(ｄａｙ)
Day
(ｈｏｕｒ)
Hour
(ｉｓｄａｔｅ)
IsDate
(ｍｉｎｕｔｅ)
Minute
(ｍｏｎｔｈ)
Month
(ｍｏｎｔｈｎａｍｅ)
MonthName
(ｎｏｗ)
Now
(ｓｅｃｏｎｄ)
Second
(ｔｉｍｅ)
Time
(ｔｉｍｅｒ)
Timer
(ｔｉｍｅｓｅｒｉａｌ)
TimeSerial
(ｔｉｍｅｖａｌｕｅ)
TimeValue
(ｗｅｅｋｄａｙ)
Weekday
(ｗｅｅｋｄａｙｎａｍｅ)
WeekdayName
(ｙｅａｒ)
Year
(ｃｂｏｏｌ)
CBool
(ｃｂｙｔｅ)
CByte
(ｃｃｕｒ)
CCur
(ｃｄａｔｅ)
CDate
(ｃｄｂｌ)
CDbl
(ｃｄｅｃ)
CDec
(ｃｉｎｔ)
CInt
(ｃｌｎｇ)
CLng
(ｃｓｎｇ)
CSng
(ｃｓｔｒ)
CStr
(ｃｖａｒ)
CVar
(ｃｖｄａｔｅ)
CVDate
(ｉｓａｒｒａｙ)
IsArray
(ｉｓｄａｔｅ)
IsDate
(ｉｓｅｍｐｔｙ)
IsEmpty
(ｉｓｎｕｌｌ)
IsNull
(ｉｓｎｕｍｅｒｉｃ)
IsNumeric
(ｉｓｏｂｊｅｃｔ)
IsObject
(ｔｙｐｅｎａｍｅ)
TypeName
(ｖａｒｔｙｐｅ)
VarType
(ａｒｒａｙ)
Array
(ｆｉｌｔｅｒ)
Filter
(ｊｏｉｎ)
Join
(ｌｂｏｕｎｄ)
LBound
(ｓｐｌｉｔ)
Split
(ｕｂｏｕｎｄ)
UBound
(ａｔｎ)
Atn
(ｃｏｓ)
Cos
(ｄｄｂ)
DDB
(ｅｘｐ)
Exp
(ｆｖ)
FV
(ｉｐｍｔ)
IPmt