'Microsoft Visual Basic for Applications Language Reference '- #Const c = 0 #If a Then #Else a = Abs(a) Activate Deactivate Events Add a = a And a AppActivate a = Array() Asc Atn Beep Dim a As Boolean Dim a As Byte Calendar Property Call a ChDir ChDrive Choose Chr Clear Close Collection Command Comparisons Const a = "" Cos Count Property CreateObject CurDir Dim a As Currency a = CVErr(a) 'Data Type Summary Dim a As Date Date Date DateAdd DateDiff DatePart DateSerial DateValue Day DDB Deactivate Debug.Print 'Decimal Declare Function MyFunction Lib "a" () Deftypes DefBool A DefByte A DefInt A DefLng A DefCur A DefSng A DefDbl A 'DefDec 1 DefDate A DefStr A DefObj A DefVar A DeleteSetting Description Dim a Dir Do While 1 Loop DoEvents Dim a As Double End Environ EOF a = a Eqv a Erase a Err Error a a = Error(a) Exit Sub Exp FileAttr FileCopy FileDateTime FileLen a = Fix(a) For Each a In a Next For a = 1 To a Next Format 'Format Different Formats for Different Numeric Values 'Format Different Formats for Different String Values 'Format Named Date/Time Formats 'Format Named Numeric Formats 'Format User-Defined Date/Time Formats 'Format User-Defined Numeric Formats 'Format User-Defined String Formats FreeFile Function a() FV Get #1, , a GetAllSettings GetAttr GetObject GetSetting GoSub a Return GoTo a HelpContext Property HelpFile Property Hex Hide Hour If a Then a Else IIf IMEStatus a = a Imp a Initialize Input #1, a a = Input(a, #1) InputBox InStr a = Int(a) a = Fix(a) Dim a As Integer IPmt IRR If a Is a Then IsArray IsDate IsEmpty IsError IsMissing IsNull IsNumeric IsObject Item Kill LastDllError Property a = LBound(a) LCase Left a = Len(a) Let a = a a = a Like a Line Input #1, a Load Loc Lock a Unlock a LOF Log Dim a As Long LSet a = a a = LTrim(a) ', RTrim, and Trim MacID MacScript a = Mid(a) 'Mid Minute MIRR MkDir a = a Mod a Month MsgBox Name a As a a = Not a Now NPer NPV Number Property Object Oct On Error GoTo a On a GoSub a ', On...GoTo Open a For Random As a Operator Precedence Option Base 1 Option Compare Text Option Explicit 'Option Private Module a = a Or a Partition Pmt PPmt Print #1, a Print PrintForm Private a Property Get a() Property Let a(a) Property Set a(a) Public a Put #1, , a PV QBColor QueryClose Raise Randomize Rate ReDim a(a) Rem Remove Reset Resize Resume RGB Right RmDir Rnd RSet a = a RTrim SaveSetting Second a = Seek(a) Seek #1, a Select Case a SendKeys Set a = a SetAttr a = Sgn(a) Shell Show Sin Dim a As Single SLN Source Property Space Print Spc(a) Sqr StartUpPosition Property Static a Stop Str StrComp StrConv Dim a As String a = String(a, a) Sub a() Switch SYD Print Tab(a) Tan Terminate Time Time Timer TimeSerial TimeValue Trim 'Type Conversions a = CBool(expression) a = CByte(expression) a = CCur(expression) a = CDate(expression) a = CDbl(expression) ''a = CDec(expression) a = CInt(expression) a = CLng(expression) a = CSng(expression) a = CVar(expression) a = CStr(expression) Type a TypeName a = UBound(a) UCase Unload Unlock a User -Defined 'UserForm, UserForms Collection Val Dim a As Variant VarType Weekday WhatsThisButton Property WhatsThisHelp Property WhatsThisMode While a Wend Width #1, a With a Write #1, a a = a Xor a Year