vb指令集1.docx

1、vb指令集1Calendar 常数: vbCalGreg vbCalHijriColor 常数: vbBlack vbRed vbGreen vbYellow vbBlue vbMagenta vbCyan vbWhiteComparison常数: VbUseCompareOption VbBinaryCompare VbTextCompare vbDatabaseCompareCompiler 常数: Win16 Win32Date 常数: vbUseSystem vbSunday vbMonday vbTuesday vbWednesday vbThursday vbFriday vbSa

2、turdayfirstdayofyear: vbUseSystem VbUseSystemDayOfWeek VbFirstJan1 vbFirstFourDays vbFirstFullWeek返回值: vbSunday vbMonday vbTuesday vbWednesday vbThursday vbFriday vbSaturday日期格式常数: vbGeneralDate vbLongDate vbShortDate vbLongTime vbShortTimeDir、GetAttr 和 SetAttr 常数: vbNormal vbReadOnly vbHidden vbSys

3、tem vbVolume vbDirectory vbArchive驱动器类型常数: Unknown Removable Fixed Remote CDROM RAMDisk文件属性常数: Normal ReadOnly Hidden System Volume Directory Archive Alias Compressed文件输入/输出常数: ForReading ForWriting ForAppendingIMEStatus 常数: vbIMEModeNoControl vbIMEModeOn vbIMEModeOff vbIMEModeDisable vbIMEModeHirag

4、ana vbIMEModeKatakana vbIMEModeKatakanaHalf vbIMEModeAlphaFull vbIMEModeAlphaKeycode 常数: vbKeyLButton vbKeyRButton vbKeyCancel vbKeyMButton vbKeyBack vbKeyTab vbKeyClear vbKeyReturn vbKeyShift vbKeyControl vbKeyMenu vbKeyPause vbKeyCapital vbKeyEscape vbKeySpace vbKeyPageUp vbKeyPageDown vbKeyEnd vb

5、KeyHome vbKeyLeft vbKeyUp vbKeyRight vbKeyDown vbKeySelect vbKeyPrint vbKeyExecute vbKeySnapshot vbKeyInsert vbKeyDelete vbKeyHelp vbKeyNumlock vbKeyA vbKeyB vbKeyC vbKeyD vbKeyE vbKeyF vbKeyG vbKeyH vbKeyI vbKeyJ vbKeyK vbKeyL vbKeyM vbKeyN vbKeyO vbKeyP vbKeyQ vbKeyR vbKeyS vbKeyT vbKeyU vbKeyV vb

6、KeyW vbKeyX vbKeyY vbKeyZ vbKey0 vbKey1 vbKey2 vbKey3 vbKey4 vbKey5 vbKey6 vbKey7 vbKey8 vbKey9 vbKeyNumpad0 vbKeyNumpad1 vbKeyNumpad2 vbKeyNumpad3 vbKeyNumpad4 vbKeyNumpad5 vbKeyNumpad6 vbKeyNumpad7 vbKeyNumpad8 vbKeyNumpad9 vbKeyMultiply vbKeyAdd vbKeySeparator vbKeySubtract vbKeyDecimal vbKeyDivi

7、de vbKeyF1 vbKeyF2 vbKeyF3 vbKeyF4 vbKeyF5 vbKeyF6 vbKeyF7 vbKeyF8 vbKeyF9 vbKeyF10 vbKeyF11 vbKeyF12 vbKeyF13 vbKeyF14 vbKeyF15 vbKeyF16Miscellaneous 常数: vbCrLf vbCr vbLf vbNewLine vbNullChar vbNullString vbObjectError vbTab vbBack vbFormFeed vbVerticalTab MsgBox 常数: vbOKOnly vbOKCancel vbAbortRetr

8、yIgnore vbYesNoCancel vbYesNo vbRetryCancel vbCritical vbQuestion vbExclamation vbDefaultButton1 vbDefaultButton2 vbDefaultButton3 vbDefaultButton4 vbApplicationModal vbSystemModal vbMsgBoxHelpButton VbMsgBoxSetForeground vbMsgBoxRight vbMsgBoxRtlReading vbOK vbCancel vbAbort vbRetry vbIgnore vbYes

9、vbNoQueryClose常数: vbFormControlMenu vbFormCode vbAppWindows vbAppTaskManagerShell 常数: vbHide vbNormalFocus vbMinimizedFocus vbMaximizedFocus vbNormalNoFocus vbMinimizeNoFocus特殊文件夹常数: WindowsFolder SystemFolder TemporaryFolderStrConv 常数: vbUpperCase vbLowerCase vbProperCase vbWide vbNarrow vbKatakana

10、 vbHiragana vbUnicode vbFromUnicodeSystem Color 常数: vbScrollBars vbDesktop vbActiveTitleBar vbInactiveTitleBar vbMenuBar vbWindowBackground vbWindowFrame vbMenuText vbWindowText vbTitleBarText vbActiveBorder vbInactiveBorder vbApplicationWorkspace vbHighlight vbHighlightText vbButtonFace vbButtonSha

11、dow vbGrayText vbButtonText vbInactiveCaptionText vb3Dhighlight vb3DDKShadow vb3Dlight vbInfoText vbInfoBackground三态常数: TristateTrue TristateFalse TristateUseDefaultVarType 常数: vbEmpty vbNull vbInteger vbLong vbSingle vbDouble vbCurrency vbDate vbString vbObject vbError vbBoolean vbVariant vbDataObj

12、ect vbDecimal vbByte vbUserDefinedType vbArray 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, proc

13、edurename, calltype,arguments()Choose(index, choice-1, choice-2, . , choice-n) Chr(charcode) CommandCos(number) CreateObject(class,servername) CurDir(drive) CVErr(errornumber) Date DateAdd(interval, number, date) DateDiff(interval, date1, date2, firstdayofweek, firstweekofyear)DatePart(interval, dat

14、e,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) F

15、ileLen(pathname) Filter(InputStrings, Value, Include, Compare) Format(expression, format, firstdayofweek, firstweekofyear)FormatCurrency(Expression,NumDigitsAfterDecimal ,IncludeLeadingDigit ,UseParensForNegativeNumbers ,GroupDigits)FormatDateTime(Date,NamedFormat) FormatPercent(Expression,NumDigits

16、AfterDecimal ,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

17、) IMEStatusInput(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(expressio

18、n) 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)

19、 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) Now NPer(rate, pmt, pv, fv, type) NPV(rate, values() Oct(number)Partition(number, start, stop, interval) Pmt(

20、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) Secon

21、d(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, charact

22、er) Switch(expr-1, value-1, expr-2, value-2 _ , expr-n,value-n)SYD(cost, salvage, life, period) Tab(n) Tan(number) TimeTimer TimeSerial(hour, minute, second) TimeValue(time) CBool(expression) CByte(expression) CCur(expression) CDate(expression)CDbl(expression) CDec(expression) CInt(expression) CLng(

23、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)数据类型概述: Byte Boolean Integer Long Single Double Currenc

24、y Decimal Date Object String String Variant Variant Type导出的数学函数: Secant Cosecant Cotangent Inverse Sine Inverse Cosine Inverse Secant Inverse Cosecant Inverse Cotangent Hyperbolic Sine Hyperbolic Cosine Hyperbolic Tangent Hyperbolic Secant Hyperbolic Cosecant Hyperbolic Cotangent Inverse Hyperbolic

25、Sine Inverse Hyperbolic Cosinenverse Hyperbolic Tangent Inverse Hyperbolic SecantInverse Hyperbolic Cosecant nverse Hyperbolic Cotangent逻辑运算符: And Eqv Imp Not Or Xor数学函数: Abs Atn Cos Exp Fix Int Log Rnd Sgn Sin Sqr Sqr运算符优先顺序: - (*、 /) Mod (+、 -) & = = Like Not And Or Xor Eqv Imp Is数组关键字总结: IsArray

26、Array Option Base Dim, Private, Public, ReDim, Static LBound, Ubound Erase, ReDimCollection 对象关键字总结: IsArray Array Option Base Dim, Private, Public, ReDim, Static LBound, Ubound Erase, ReDim编译命令关键字总结: #Const #If.Then.#Else控制流关键字总结: GoSub.Return, GoTo, On Error, On.GoSub, On.GoTo DoEvents, End, Exit,

27、 Stop Do.Loop For.Next, For Each.Next, While.Wend, With Choose, If.Then.Else, Select Case, Switch Call, Function, Property Get, Property Let, Property Set, Sub变换关键字总结: Chr Format, LCase, UCase DateSerial, DateValue Hex, Oct Format, Str CBool, CByte, CCur, CDate, CDbl, CDec, CInt, CLng, CSng, CStr, C

28、Var, CVErr, Fix, Int Day, Month, Weekday, Year Hour, Minute, Second Asc Val 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, IsD

29、ate, IsEmpty, IsError, IsMissing, IsNull, IsNumeric, IsObject日期与时间关键字总: Date ,Now, Time DateAdd, DateDiff, DatePart DateSerial, DateValue TimeSerial, TimeValue Date, Time Timer目录和文件关键字总结: ChDir ChDrive FileCopy MkDir RmDir Name CurDir FileDateTime GetAttr FileLen Dir SetAttr 错误关键字总结: Clear, Error, R

30、aise Error Err CVErr On Error, Resume IsError金融关键字总结: DDB, SLN, SYD FV Rate IRR, MIRR NPer IPmt, Pmt, PPmt NPV, PV 输入与输出关键字总结: DDB, SLN, SYD FV Rate IRR, MIRR NPer IPmt, Pmt, PPmt NPV, PV 数学关键字总结: Atn, Cos, Sin, Tan Exp, Log, Sqr Randomize, Rnd Abs Sgn Fix, Int 其他关键字总结: DoEvents AppActivate, Shell S

31、endKeys Beep Environ Command MacID, MacScript CreateObject, GetObject QBColor, RGB运算符关键字总结: DoEvents AppActivate, Shell SendKeys Beep Environ Command MacID, MacScript CreateObject, GetObject QBColor, RGB注册关键字总结: DoEvents AppActivate, Shell SendKeys Beep Environ Command MacID, MacScript CreateObject, GetObject QBColor, RGB字符串处理关键字总结: StrComp StrConv Format, L