Book description
The online documentation of VB/VBA language components seems to follow the 80/20 rule: the basic facts that you need to use a language statement are provided in the documentation. But the additional 20 percent that you need to use it effectively or to apply it to special cases is conspicuously absent. To a professional VB/VBA programmer, though, this missing 20 percent of the language's documentation isn't a luxury, it's a necessity. And in VB & VBA in a Nutshell: The Language, it finally is available. The bulk of the book consists of an alphabetical reference to the statements, procedures, and functions of the VB/VBA language. Each entry has a standardized listing containing the following information:
Its syntax, using standard code conventions
Differences in the operation of the keyword in a macro environment (e.g., in Office) and in Visual Basic, if there are any
A list of arguments accepted by the function or procedure, if any
A description of the data type returned by a function
The finer points of a keyword's usage that are often omitted from or blurred over by the documentation
Tips and gotchas that include undocumented behaviors and practical applications for particular language elements -- a section particularly invaluable for diagnosing or avoiding potential programming problems
A brief, nonobvious example that illustrates the use of the keyword
Basic VBA programming concepts, such as its data types and its support for variables, constants, and arrays
Error handling in VBA applications
Object programming with VBA
Using VBA with particular applications. Excel and Project are utilized to show how to work with an application's integrated development environment and to take advantage of its object model Regardless of how much experience you have programming with VBA, this is the book you'll pick up time and time again both as your standard reference guide and as a tool for troubleshooting and identifying programming problems.
Also included in VB & VBA in a Nutshell: The Language is a brief overview of the VB/VBA language, including:
VB & VBA in a Nutshell: The Language is the definitive reference for Visual Basic and VBA developers.
Table of contents
- 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
Product information
- Title: VB & VBA in a Nutshell: The Language
- Author(s):
- Release date: October 1998
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9781565923584
You might also like
book
Programming Excel with VBA and .NET
Why program Excel? For solving complex calculations and presenting results, Excel is amazingly complete with every …
book
Microsoft® Access® 2010 VBA Programming Inside Out
You're beyond the basics, so dive right in and customize, automate, and extend Access—using Visual Basic …
book
Programming Excel with VBA: A Practical Real-World Guide
Learn to harness the power of Visual Basic for Applications (VBA) in Microsoft Excel to develop …
book
Excel 2013 Power Programming with VBA
Maximize your Excel 2013 experience using VBA application development The new Excel 2013 boasts updated features, …