- Copyright
- Preface
- The Basics
- Reference
- The Language Reference
- The Language Reference, Part 1: #Const Directive–Drives Collection Object (VB6)
- #Const Directive
- #If...Then...#Else Directive
- Abs Function
- AddressOf Operator
- AppActivate Statement
- Array Function
- Asc, AscB, AscW Functions
- Atn Function
- Beep Statement
- BindingCollection Object (VB6)
- BindingCollection.Add Method (VB6)
- BindingCollection.Clear Method (VB6)
- BindingCollection Remove.Method (VB6)
- Binding Object (VB6)
- Calendar Property
- Call Statement
- CallByName Function (VB6)
- CBool Function
- CByte Function
- CCur Function
- CDate Function
- CDbl Function
- CDec Function
- ChDir Statement
- ChDrive Statement
- Choose Function
- Chr, Chr$, ChrB, ChrB$, ChrW Functions
- CInt Function
- CLng Function
- Close Statement
- Collection Object
- Collection.Add Method
- Collection.Count Property
- Collection.Item Method
- Collection.Remove Method
- Command Function
- Const Statement
- Cos Function
- CreateObject Function
- CSng Function
- CStr Function
- CurDir, CurDir$ Functions
- CVar Function
- CVDate Function
- CVErr Function
- Data Binding Objects (VB6)
- Data Format Objects (VB6)
- DataBindingBehavior Property (VB6 only)
- DataSourceBehavior Property (VB6 only)
- Date, Date$ Functions
- Date Statement
- DateAdd Function
- DateDiff Function
- DatePart Function
- DateSerial Function
- DateValue Function
- Day Function
- DDB Function
- Debug Object
- Debug.Assert Method
- Debug.Print Method
- Declare Statement
- Def... Statement
- DeleteSetting Statement
- Dictionary Object (VB6)
- Dictionary.Add Method (VB6)
- Dictionary.CompareMode Property (VB6)
- Dictionary.Count Property (VB6)
- Dictionary.Exists Method (VB6)
- Dictionary.Item Property (VB6)
- Dictionary.Items Method (VB6)
- Dictionary.Key Property (VB6)
- Dictionary.Keys Method (VB6)
- Dictionary.Remove Method (VB6)
- Dictionary.RemoveAll Method (VB6)
- Dim Statement
- Dir, Dir$ Functions
- Do...Loop Statement
- DoEvents Function
- Drive Object (VB6)
- Drives Collection Object (VB6)
- The Language Reference, Part 2: End... Statement–FV Function
- End... Statement
- Enum Statement
- Environ, Environ$ Functions
- EOF Function
- Erase Statement
- Err Object
- Err.Clear Method
- Err.Description Property
- Err.HelpContext Property
- Err.HelpFile Property
- Err.LastDLLError Property
- Err.Number Property
- Err.Raise Method
- Err.Source Property
- Error, Error$ Functions
- Error Statement
- Event Statement
- Exit Statement
- Exp Function
- File Object (VB6)
- File.Copy Method (VB6)
- File.Delete Method (VB6)
- File.Move Method (VB6)
- File.OpenAsTextStream Method (VB6)
- File System Object Model (VB6)
- FileAttr Function
- FileCopy Statement
- FileDateTime Function
- FileLen Function
- Files Collection Object (VB6)
- FileSystemObject Object (VB6)
- FileSystemObject.BuildPath Method (VB6)
- FileSystemObject.CopyFile Method (VB6)
- FileSystemObject.CopyFolder Method (VB6)
- FileSystemObject.CreateFolder Method (VB6)
- FileSystemObject.CreateTextFile Method (VB6)
- FileSystemObject.DeleteFile Method (VB6)
- FileSystemObject.DeleteFolder Method (VB6)
- FileSystemObject.DriveExists Method (VB6)
- FileSystemObject.Drives Property (VB6)
- FileSystemObject.FileExists Method (VB6)
- FileSystemObject.FolderExists Method (VB6)
- FileSystemObject.GetAbsolutePathName Method (VB6)
- FileSystemObject.GetBaseName Method (VB6)
- FileSystemObject.GetDrive Method (VB6)
- FileSystemObject.GetDriveName Method (VB6)
- FileSystemObject.GetExtensionName Method (VB6)
- FileSystemObject.GetFile Method (VB6)
- FileSystemObject.GetFileName Method (VB6)
- FileSystemObject.GetFolder Method (VB6)
- FileSystemObject.GetParentFolderName Method (VB6)
- FileSystemObject.GetSpecialFolder Method (VB6)
- FileSystemObject.GetTempName Method (VB6)
- FileSystemObject.MoveFile Method (VB6)
- FileSystemObject.MoveFolder Method (VB6)
- FileSystemObject.OpenTextFile Method (VB6)
- Filter Function (VB6)
- Fix Function
- Folder Object (VB6)
- Folder.Copy Method (VB6)
- Folder.CreateTextFile Method (VB6)
- Folder.Delete Method (VB6)
- Folder.Move Method (VB6)
- Folders Collection Object (VB6)
- Folders.Add Method (VB6)
- For...Next Statement
- For Each...Next Statement
- Format, Format$ Functions
- FormatCurrency, FormatNumber, FormatPercent Functions (VB6)
- FormatDateTime Function (VB6)
- FreeFile Function
- Function Statement
- FV Function
- The Language Reference, Part 3: Get Statement–PV Function
- Get Statement
- GetAllSettings Function
- GetAttr Function
- GetAutoServerSettings Function
- GetObject Function
- GetSetting Function
- GoSub...Return Statement
- Goto Statement
- Hex, Hex$ Functions
- Hour Function
- If...Then...Else Statement
- IIf Function
- IMEStatus Function
- Implements Statement
- Initialize Event
- Input, Input$, InputB, InputB$ Functions
- Input # Statement
- InputBox Function
- Instancing Property (VB only)
- InStr, InStrB Functions
- InstrRev Function (VB6)
- Int Function
- IPmt Function
- IRR Function
- IsArray Function
- IsDate Function
- IsEmpty Function
- IsError Function
- IsMissing Function
- IsNull Function
- IsNumeric Function
- IsObject Function
- Join Function (VB6)
- Kill Statement
- LBound Function
- LCase, LCase$ Functions
- Left, Left$, LeftB, LeftB$ Functions
- Len, LenB Functions
- Like Operator
- Line Input# Statement
- Load Statement
- LoadResData Function
- LoadResPicture Function
- LoadResString Function
- Loc Function
- Lock Statement
- LOF Function
- Log Function
- LSet Statement
- LTrim, LTrim$ Functions
- Me Operator
- Mid, Mid$, MidB, MidB$ Functions
- Mid, MidB Statements
- Minute Function
- MIRR Function
- MkDir Statement
- Month Function
- MonthName Function (VB6)
- MsgBox Function
- MTSTransactionMode Property (VB6 only)
- Name Property
- Name Statement
- Now Function
- NPer Function
- NPV Function
- Oct, Oct$ Functions
- On Error Statement
- Open Statement
- Option Base Statement
- Option Compare Statement
- Option Explicit Statement
- Option Private Module Statement
- Persistable Property (VB6 Only)
- Pmt Function
- PPmt Function
- Print # Statement
- Printer Object and Printers Collection
- Private Statement
- Property Get Statement
- Property Let Statement
- Property Set Statement
- Public Statement
- Put Statement
- PV Function
- The Language Reference, Part 4: QBColor Function–Year Function
- QBColor Function
- RaiseEvent Statement
- Randomize Statement
- Rate Function
- ReDim Statement
- Rem Statement
- Replace Function (VB6)
- Reset Statement
- Resume Statement
- Return Statement
- RGB Function
- Right, Right$, RightB, RightB$ Functions
- RmDir Statement
- Rnd Function
- Round Function
- RSet Statement
- RTrim, RTrim$ Functions
- SaveSetting Statement
- Second Function
- Seek Function
- Seek Statement
- Select Case Statement
- SendKeys Statement
- Set Statement
- SetAttr Statement
- Sgn Function
- Shell Function
- Sin Function
- SLN Function
- Space, Space$ Functions
- Spc Function
- Split Function (VB6)
- Sqr Function
- Static Statement
- stdDataFormat Object (VB6)
- stdDataFormats Object (VB6)
- Stop Statement
- Str, Str$ Functions
- StrComp Function
- StrConv Function
- String, String$ Functions
- StrReverse Function (VB6)
- Sub Statement
- Switch Function
- SYD Function
- Tab Function
- Tan Function
- Terminate Event
- TextStream Object
- TextStream.Close Method
- TextStream.Read Method
- TextStream.ReadAll Method
- TextStream.ReadLine Method
- TextStream.Skip Method
- TextStream.SkipLine Method
- TextStream.Write Method
- TextStream.WriteBlankLines Method
- TextStream.WriteLine Method
- Time, Time$ Functions
- Time Statement
- Timer Function
- TimeSerial Function
- TimeValue Function
- Trim, Trim$ Functions
- Type Statement
- TypeName Function
- UBound Function
- UCase, UCase$ Functions
- Unload Statement
- Unlock Statement
- Val Function
- VarType Function
- Weekday Function
- WeekdayName Function (VB6)
- While...Wend Statement
- Width # Statement
- With Statement
- WithEvents Keyword
- Write # Statement
- Year Function
- Appendixes
- Language Elements by Category
- Collection Object
- Conditional Compilation
- Data Type Conversion Functions
- Data Bindings Objects (VB6 only)
- Date and Time Functions
- Dictionary Object (VB6 Only)
- Err Object
- FileSystem Objects (VB6 only)
- File and Folder Handling
- Financial Functions
- Formatting Functions
- Information Functions
- Interaction Functions
- Math Functions
- Programming and ActiveX Programming
- Printer Object
- Program Structure and Flow
- Registry Functions
- String Manipulation
- Variable Declaration
- Language Constants
- Application Window Style (VbAppWinStyle)
- Calendar (VBCalendar)
- Call Type (VB6 only)
- Compare Method (VbCompareMethod)
- Data Binding Update Mode (VB6 Only)
- Date Time Format Styles (VB6 Only)
- Day of Week (VbDayOfWeek)
- Drive Type (VB6 only)
- File Attributes (VbFileAttribute)
- File System Objects File Attributes (VB6 Only)
- First Week of Year (VbFirstWeekOfYear)
- IME Status (VbIMEStatus)
- Language Constants
- Log Event Type Style (LogEventTypeConstants)
- Log Mode Constants (VB6 only)
- Message Box Result (VbMsgBoxResult)
- Message Box Style (VbMsgBoxStyle)
- Special Folder Types (VB6 only)
- String Conversion (VbStrConv)
- TextStream IOMode (VB6 only)
- Tristate Constants (VB6 Only)
- Variant Type (VbVarType)
- Operators
- What's New in VB6?
- Language Elements by Category
- Colophon
- Index
Part II: The Basics
This section serves as a general introduction to Visual Basic for Applications, the programming language that is common to both Visual Basic and to a range of host applications, including most of the applications in the Microsoft Office suite. Taken together, these chapters form an extremely fast-paced introduction to the most critical VBA programming topics. If you're an experienced programmer who is learning VBA as a second (or additional) programming language, this material should help to familiarize you with VBA in as short a time as possible. If you have some experience with VBA programming, you'll want to read Chapter 4 and Chapter 5 on class modules and automation, since they discuss two of the newer and most significant technologies incorporated into the VBA language.
In addition to its role as a tutorial, Chapter 3 is an essential reference to the data types supported by VBA.
Part I consists of the following chapters:
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.