Errata for Writing Excel Macros with VBA
Submit your own errata for this product.
The errata list is a list of errors and their corrections that were found after the product was released. If the error was corrected in a later version or reprint the date of the correction will be displayed in the column titled "Date Corrected".
The following errata were submitted by our customers and approved as valid errors by the author or editor.
Color Key: Serious Technical Mistake Minor Technical Mistake Language or formatting error Typo Question Note Update
| Version |
Location |
Description |
Submitted By |
Date Submitted |
Date Corrected |
| Printed |
Page xii
IN PRINT: 3rd paragraph, last line |
"...such as support for text-to-speed and..."
NOW READS:
"...such as support for text-to-speech and..."
|
Anonymous |
|
Nov 01, 2003 |
| Printed |
Page xi
third paragraph |
"...such as my Enhanced Object Browser, a coupon for which is included in the back of this book"
NOW READS:
"...such as my Enhanced Object Browser."
|
Anonymous |
|
Aug 01, 2004 |
| Printed |
Page 19
paragraph 2 says |
"Excel recognizes 19 events related to workbooks ..."
Table 11-2 on page 134 shows 21
|
Anonymous |
|
|
| Printed |
Page 19
paragraph 4 says |
"Excel recognizes 7 events related to worksheets ..."
Table 11-1 on page 132 shows 8
|
Anonymous |
|
|
| Printed |
Page 96
Top Code Example of For Each Loop |
In the general syntax definition of the For Each loop, the word "Each" was omitted.
First line of code sample NOW READS:
For Each ObjectVar In CollectionName
|
Anonymous |
|
Nov 01, 2003 |
| Printed |
Page 97
1st Do While example code |
Do While IsEmpty (Activesheet.Rows(1).Cells(i))
NOW READS:
Do While Not IsEmpty (Activesheet.Rows(1).Cells(i))
|
Anonymous |
|
Aug 01, 2004 |
| Printed |
Page 97
6th paragraph, starting "Just as the for loop..." |
last word on 1st line, "as"
NOW READS:
"has"
|
Anonymous |
|
Aug 01, 2004 |
| Printed |
Page 152
Example 12-8 - "Macro Invoked by Selecting a Composer from the List Box" |
Find the list box control
NOW READS:
' Find the list box control
|
Anonymous |
|
Nov 01, 2003 |
