Errata

Writing Excel Macros with VBA

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