vb指令集1.docx
《vb指令集1.docx》由会员分享,可在线阅读,更多相关《vb指令集1.docx(23页珍藏版)》请在冰豆网上搜索。
vb指令集1
Calendar常数:
vbCalGregvbCalHijri
Color常数:
vbBlackvbRedvbGreenvbYellowvbBluevbMagentavbCyanvbWhite
Comparison常数:
VbUseCompareOptionVbBinaryCompareVbTextCompare
vbDatabaseCompare
Compiler常数:
Win16Win32
Date常数:
vbUseSystemvbSundayvbMondayvbTuesdayvbWednesday
vbThursdayvbFridayvbSaturday
firstdayofyear:
vbUseSystemVbUseSystemDayOfWeekVbFirstJan1
vbFirstFourDaysvbFirstFullWeek
返回值:
vbSundayvbMondayvbTuesdayvbWednesday
vbThursdayvbFridayvbSaturday
日期格式常数:
vbGeneralDatevbLongDatevbShortDatevbLongTime
vbShortTime
Dir、GetAttr和SetAttr常数:
vbNormalvbReadOnlyvbHiddenvbSystem
vbVolumevbDirectoryvbArchive
驱动器类型常数:
UnknownRemovableFixedRemoteCDROMRAMDisk
文件属性常数:
NormalReadOnlyHiddenSystemVolumeDirectory
ArchiveAliasCompressed
文件输入/输出常数:
ForReadingForWritingForAppending
IMEStatus常数:
vbIMEModeNoControlvbIMEModeOnvbIMEModeOff
vbIMEModeDisablevbIMEModeHiraganavbIMEModeKatakana
vbIMEModeKatakanaHalfvbIMEModeAlphaFullvbIMEModeAlpha
Keycode常数:
vbKeyLButtonvbKeyRButtonvbKeyCancelvbKeyMButton
vbKeyBackvbKeyTabvbKeyClearvbKeyReturnvbKeyShift
vbKeyControlvbKeyMenuvbKeyPausevbKeyCapital
vbKeyEscapevbKeySpacevbKeyPageUpvbKeyPageDown
vbKeyEndvbKeyHomevbKeyLeftvbKeyUpvbKeyRight
vbKeyDownvbKeySelectvbKeyPrintvbKeyExecute
vbKeySnapshotvbKeyInsertvbKeyDeletevbKeyHelp
vbKeyNumlock
vbKeyAvbKeyBvbKeyCvbKeyDvbKeyEvbKeyFvbKeyG
vbKeyHvbKeyIvbKeyJvbKeyKvbKeyLvbKeyMvbKeyN
vbKeyOvbKeyPvbKeyQvbKeyRvbKeySvbKeyTvbKeyU
vbKeyVvbKeyWvbKeyXvbKeyYvbKeyZ
vbKey0vbKey1vbKey2vbKey3vbKey4vbKey5vbKey6
vbKey7vbKey8vbKey9
vbKeyNumpad0vbKeyNumpad1vbKeyNumpad2vbKeyNumpad3
vbKeyNumpad4vbKeyNumpad5vbKeyNumpad6vbKeyNumpad7
vbKeyNumpad8vbKeyNumpad9vbKeyMultiplyvbKeyAdd
vbKeySeparatorvbKeySubtractvbKeyDecimalvbKeyDivide
vbKeyF1vbKeyF2vbKeyF3vbKeyF4vbKeyF5vbKeyF6
vbKeyF7vbKeyF8vbKeyF9vbKeyF10vbKeyF11vbKeyF12
vbKeyF13vbKeyF14vbKeyF15vbKeyF16
Miscellaneous常数:
vbCrLfvbCrvbLfvbNewLinevbNullChar
vbNullStringvbObjectErrorvbTabvbBack
vbFormFeedvbVerticalTab
MsgBox常数:
vbOKOnlyvbOKCancelvbAbortRetryIgnorevbYesNoCancel
vbYesNovbRetryCancelvbCriticalvbQuestionvbExclamationvbDefaultButton1vbDefaultButton2
vbDefaultButton3vbDefaultButton4vbApplicationModal
vbSystemModalvbMsgBoxHelpButtonVbMsgBoxSetForeground
vbMsgBoxRightvbMsgBoxRtlReading
vbOKvbCancelvbAbortvbRetryvbIgnorevbYesvbNo
QueryClose常数:
vbFormControlMenuvbFormCodevbAppWindows
vbAppTaskManager
Shell常数:
vbHidevbNormalFocusvbMinimizedFocusvbMaximizedFocus
vbNormalNoFocusvbMinimizeNoFocus
特殊文件夹常数:
WindowsFolderSystemFolderTemporaryFolder
StrConv常数:
vbUpperCasevbLowerCasevbProperCasevbWidevbNarrow
vbKatakanavbHiraganavbUnicodevbFromUnicode
SystemColor常数:
vbScrollBarsvbDesktopvbActiveTitleBar
vbInactiveTitleBarvbMenuBarvbWindowBackground
vbWindowFramevbMenuTextvbWindowTextvbTitleBarText
vbActiveBordervbInactiveBordervbApplicationWorkspace
vbHighlightvbHighlightTextvbButtonFacevbButtonShadowvbGrayTextvbButtonTextvbInactiveCaptionText
vb3Dhighlightvb3DDKShadowvb3DlightvbInfoText
vbInfoBackground
三态常数:
TristateTrueTristateFalseTristateUseDefault
VarType常数:
vbEmptyvbNullvbIntegervbLongvbSinglevbDouble
vbCurrencyvbDatevbStringvbObjectvbErrorvbBoolean
vbVariantvbDataObjectvbDecimalvbBytevbUserDefinedTypevbArray
Boolean数据类型Byte数据类型Currency数据类型Date数据类型
Decimal数据类型Double数据类型Integer数据类型Long数据类型
Object数据类型Single数据类型String数据类型用户定义数据类型
Variant数据类型
#Const指令#If...Then...#Else指令Abs(number)Array(arglist)Asc(string)
Atn(number)CallByName(object,procedurename,calltype,[arguments()])
Choose(index,choice-1[,choice-2,...[,choice-n]])Chr(charcode)Command
Cos(number)CreateObject(class,[servername])CurDir[(drive)]CVErr(errornumber)DateDateAdd(interval,number,date)
DateDiff(interval,date1,date2[,firstdayofweek[,firstweekofyear]])
DatePart(interval,date[,firstdayofweek[,firstweekofyear]])
DateSerial(year,month,day)DateValue(date)Day(date)
DDB(cost,salvage,life,period[,factor])Dir[(pathname[,attributes])]
DoEvents()Environ({envstring|number})EOF(filenumber)Error[(errornumber)]Exp(number)FileAttr(filenumber,returntype)FileDateTime(pathname)
FileLen(pathname)Filter(InputStrings,Value[,Include[,Compare]])
Format(expression[,format[,firstdayofweek[,firstweekofyear]]])
FormatCurrency(Expression[,NumDigitsAfterDecimal[,IncludeLeadingDigit[,UseParensForNegativeNumbers[,GroupDigits]]]])
FormatDateTime(Date[,NamedFormat])
FormatPercent(Expression[,NumDigitsAfterDecimal[,IncludeLeadingDigit[,UseParensForNegativeNumbers[,GroupDigits]]]])
FreeFile[(rangenumber)]FV(rate,nper,pmt[,pv[,type]])
GetAllSettings(appname,section)GetAttr(pathname)
GetObject([pathname][,class])GetSetting(appname,section,key[,default])
Hex(number)Hour(time)IIf(expr,truepart,falsepart)IMEStatus
Input(number,[#]filenumber)
InputBox(prompt[,title][,default][,xpos][,ypos][,helpfile,context])
InStr([start,]string1,string2[,compare])
InstrRev(string1,string2[,start[,compare]])
Int(number)Fix(number)IPmt(rate,per,nper,pv[,fv[,type]])
IRR(values()[,guess])IsArray(varname)IsDate(expression)IsEmpty(expression)IsError(expression)IsMissing(argname)IsNull(expression)IsNumeric(expression)IsObject(identifier)
Join(list[,delimiter])LBound(arrayname[,dimension])LCase(string)
Left(string,length)Len(string|varname)Loc(filenumber)LOF(filenumber)
Log(number)LTrim(string)RTrim(string)Trim(string)
Mid(string,start[,length])Minute(time)
MIRR(values(),finance_rate,reinvest_rate)Month(date)
MonthName(month[,abbreviate])
MsgBox(prompt[,buttons][,title][,helpfile,context])
NowNPer(rate,pmt,pv[,fv[,type]])NPV(rate,values())Oct(number)
Partition(number,start,stop,interval)Pmt(rate,nper,pv[,fv[,type]])
PPmt(rate,per,nper,pv[,fv[,type]])PV(rate,nper,pmt[,fv[,type]])
QBColor(color)Rate(nper,pmt,pv[,fv[,type[,guess]]])
Replace(expression,find,replacewith[,start[,count[,compare]]])
RGB(red,green,blue)Right(string,length)Rnd[(number)]
Round(expression[,numdecimalplaces])Second(time)Seek(filenumber)
Sgn(number)Shell(pathname[,windowstyle])Sin(number)
SLN(cost,salvage,life)Space(number)Spc(n)
Split(expression[,delimiter[,count[,compare]]])
Sqr(number)Str(number)StrComp(string1,string2[,compare])
StrConv(string,conversion,LCID)StrReverse(string1)
String(number,character)
Switch(expr-1,value-1[,expr-2,value-2_[,expr-n,value-n]])
SYD(cost,salvage,life,period)Tab[(n)]Tan(number)Time
TimerTimeSerial(hour,minute,second)TimeValue(time)
CBool(expression)CByte(expression)CCur(expression)CDate(expression)
CDbl(expression)CDec(expression)CInt(expression)CLng(expression)
CSng(expression)CStr(expression)CVar(expression)CStr(expression)
TypeName(varname)UBound(arrayname[,dimension])UCase(string)VarType(varname)Weekday(date,[firstdayofweek])
WeekdayName(weekday,abbreviate,firstdayofweek)Year(date)
数据类型概述:
ByteBooleanIntegerLongSingleDoubleCurrency
DecimalDateObjectStringStringVariantVariant
Type
导出的数学函数:
SecantCosecantCotangentInverseSine
InverseCosineInverseSecantInverseCosecant
InverseCotangentHyperbolicSineHyperbolicCosine
HyperbolicTangentHyperbolicSecant
HyperbolicCosecantHyperbolicCotangent
InverseHyperbolicSineInverseHyperbolicCosine
nverseHyperbolicTangentInverseHyperbolicSecant
InverseHyperbolicCosecantnverseHyperbolicCotangent
逻辑运算符:
AndEqvImpNotOrXor
数学函数:
AbsAtnCosExpFixIntLogRndSgnSinSqrSqr
运算符优先顺序:
^-(*、/)\Mod(+、-)&
=<><><=>=Like
NotAndOrXorEqvImpIs
数组关键字总结:
IsArray
Array
OptionBase
Dim,Private,Public,ReDim,Static
LBound,Ubound
Erase,ReDim
Collection对象关键字总结:
IsArray
Array
OptionBase
Dim,Private,Public,ReDim,Static
LBound,Ubound
Erase,ReDim
编译命令关键字总结:
#Const
#If...Then...#Else
控制流关键字总结:
GoSub...Return,GoTo,OnError,On...GoSub,On...GoTo
DoEvents,End,Exit,Stop
Do...LoopFor...Next,ForEach...Next,While...Wend,With
Choose,If...Then...Else,SelectCase,Switch
Call,Function,PropertyGet,PropertyLet,PropertySet,Sub
变换关键字总结:
ChrFormat,LCase,UCaseDateSerial,DateValue
Hex,OctFormat,Str
CBool,CByte,CCur,CDate,CDbl,CDec,CInt,CLng,CSng,CStr,CVar,CVErr,Fix,Int
Day,Month,Weekday,Year
Hour,Minute,SecondAscVal
TimeSerial,TimeValue
数据类型关键字总结:
CBool,CByte,CCur,CDate,CDbl,CDec,CInt,CLng,CSng,CStr,CVar,CVErr,Fix,Int
Boolean,Byte,Currency,Date,Double,Integer,Long,Obect,Single,String,Variant(default)
IsArray,IsDate,IsEmpty,IsError,IsMissing,IsNull,IsNumeric,IsObject
日期与时间关键字总:
Date,Now,TimeDateAdd,DateDiff,DatePart
DateSerial,DateValueTimeSerial,TimeValue
Date,TimeTimer
目录和文件关键字总结:
ChDirChDriveFileCopyMkDir
RmDirNameCurDirFileDateTime
GetAttrFileLenDirSetAttr
错误关键字总结:
Clear,Error,RaiseErrorErrCVErr
OnError,ResumeIsError
金融关键字总结:
DDB,SLN,SYDFVRateIRR,MIRR
NPerIPmt,Pmt,PPmtNPV,PV
输入与输出关键字总结:
DDB,SLN,SYDFVRateIRR,MIRRNPerIPmt,Pmt,PPmtNPV,PV
数学关键字总结:
Atn,Cos,Sin,TanExp,Log,SqrRandomize,Rnd
AbsSgnFix,Int
其他关键字总结:
DoEventsAppActivate,ShellSendKeys
BeepEnvironCommandMacID,MacScript
CreateObject,GetObjectQBColor,RGB
运算符关键字总结:
DoEventsAppActivate,ShellSendKeys
BeepEnvironCommandMacID,MacScript
CreateObject,GetObjectQBColor,RGB
注册关键字总结:
DoEventsAppActivate,ShellSendKeys
BeepEnvironCommandMacID,MacScript
CreateObject,GetObjectQBColor,RGB
字符串处理关键字总结:
StrCompStrConvFormat,L