MCSD in a Nutshell: The Visual Basic Exams
by James Foxall


This page contains changes made in the 1/01 reprint.


Here's a key to the markup:

        [page-number]: serious technical mistake
        {page-number}: minor technical mistake
        <page-number>: important language/formatting problem
        (page-number): language change or minor formatting problem
        ?page-number?: reader question or request for clarification


(xvii)  The text of the "Request for Comments" section has been updated.  It 
now reads:

Comments and Questions

The information in this book has been tested and verified, but you may find 
that features have changed (or you may even find mistakes!). You can send any 
errors you find, as well as suggestions for future editions, to:

        O'Reilly & Associates
        101 Morris Street
        Sebastopol, CA 95472
        (800) 998-9938 (in the United States or Canada)
        (707) 829-0515 (international/local)
        (707) 829-0104 (fax)

There is a web site for this book, where examples, errata, and any plans for 
future editions are listed. The site also includes a link to a forum where you 
can discuss the book with the author and other readers. You can access this 
site at:

        http://www.oreilly.com/catalog/mcsdnut/

To ask technical questions or comment on the book, send email to:

        bookquestions@oreilly.com

For more information about our books, conferences, software, Resource Centers, 
and the O'Reilly Network, see our web site at:

        http://www.oreilly.com

For technical information on Visual Basic programming, to participate in VB 
discussion forums, or to acquaint yourself with O'Reilly's line of Visual 
Basic books, you can access the O'Reilly Visual Basic web site at:

        http://vb.oreilly.com


(xviii)  The following text has been inserted as the second paragraph in the
Acknowledgments:

        "I would also like to thank the book's tech reviewers, Daniel Creeron 
        and Matt Childs, for their help in making this a more comprehensible, 
        more accurate book."


{12}  Line 8 in the code example did read:

        Set nodExample = TreeView1.Nodes.Add(lngIndex, _tvwChild)

Now reads:

        Set nodExample = TreeView1.Nodes.Add(lngIndex, tvwChild)


{54}  The answer options for question 2 did read:

        a. 1
        b. 2

They now read:

        a. 0
        b. 1
        c. 2

{58}  Item 11 did read: 

        Next, use the Range object again to select a range of cells. Enter
        this line of code to select the 4 cells in which you have placed data:

        objExcel.Range("A1:D1").Select

Now reads:

        Next, use the Range object again to select a cell to hold a formula.
        Enter this line of code to select the cell to the right of the cells
        in which you have placed data:

        objExcel.Range("E1").Select


{59}  Lines 12-15 in the code sample at the top of the page did read:

        objExcel.Range("A1:D1").Select

        objExcel.Range("E1").Activate

        objExcel.ActiveCell.FormulaR1C1 = "=SUM(RC[-4]:RC[-1])"

        objExcel.Range("A1:E1").Select

They now read:

        objExcel.Range("E1").Select

        objExcel.ActiveCell.FormulaR1C1 = "=sum(RC[-4]:RC[-1])"

        objExcel.Range("A1:E1").Select

        objExcel.Range("E1").Activate


{81}  Figure 4-6 has been replaced.  In the drop-down box in the top right
corner, "MyObject" on the top line has been replaced with "BeforeUpdate" and 
"MyObject" on the bottom line has been replaced with "BeforeUpdate" and 
"MyEvent".


{359}  The answer for question 11 should be "c," not "a."


{413}  The code line under item 21 did read:

        IsNumeric(Text1.Text) = True

Now reads:

        Debug.Assert IsNumeric(Text1.Text) = True


{441}  Item 1 in Section 1 did read:

        "Start Visual Basic and create a new ActiveX EXE."

Now reads:

        "Start Visual Basic and create a new Standard EXE project."


{446}  Item 1 in Section 1 did read:

        "Start Visual Basic and create a new ActiveX EXE."

Now reads:

        "Start Visual Basic and create a new Standard EXE project."


(447)  The first line on the page did read:

        "Add a new command button..."

Now reads:

        "Add a new text box..."


{447}  Figure 10-10 has been replaced with a figure illustrating Example 10-2.


(499)  The 3rd line of the 1st paragraph did read:

        "your custom Setup Wizard..."

Now reads:

        "your custom Package and Deployment Wizard..."


(512)  The title of Table 13-5 did read:

        "Setup Wizard Path Macros"

Now reads:

        "Package and Deployment Wizard Path Macros"


(544)  In the last bulleted item, changed "Setup Wizard" to "Package and 
Deployment Wizard."


(545)  In the 4th, 6th, and 7th bulleted items, changed "Setup Wizard" to 
"Package and Deployment Wizard."


(545)  Deleted the 8th bulleted item.


(546)  In the 2nd and 3rd bulleted items, changed "Setup Wizard" to "Package 
and Deployment Wizard."


(548)  In question 7, changed "Setup Wizard" to "Package and Deployment 
Wizard."


(549)  In questions 10, 11, and 12, changed "Setup Wizard" to "Package and 
Deployment Wizard."


(550)  In question 22, changed "Setup Wizard" to "Package and Deployment 
Wizard."


(551)  In question 24, changed "Setup Wizard" to "Package and Deployment 
Wizard."


{552}  The answer to question 2 should be "b," not "c."