Microsoft KB Archive/92564

{|
 * width="100%"|

Excel: Dialog Box Initialization Example Incorrect

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, versions 3.0, 4.0
 * Microsoft Excel for the Macintosh, versions 3.0, 4.0

-

Microsoft Excel Version 4.0
On page 274 of the version 4.0 &quot;Microsoft Excel User's Guide 2,&quot; in the &quot;Setting Initial Values and Returning Values&quot; section, the example for using the SET.VALUE function to set the initial value for a dialog box item is incorrect.

The first paragraph refers to setting the value in the &quot;Integer edit box&quot;; it should refer to the &quot;Number edit box.&quot; Also, the formula sample shows the incorrect cell reference to the Number edit box.

Microsoft Excel Version 3.0
The errors mentioned above also occur in the version 3.0 &quot;Microsoft Excel User's Guide&quot; on the following pages:


 * On page 634 of the version 3.0 &quot;Microsoft Excel User's Guide&quot; for Windows.

-and-
 * On page 629 of the version 3.0 &quot;Microsoft Excel User's Guide&quot; for the Macintosh.

MORE INFORMATION
In the first paragraph on page 274 of the version 4.0 &quot;Microsoft Excel User's Guide 2,&quot; the second sentence reads, &quot;For example, if you want the integer edit box labeled ... .&quot; This should read, &quot;For example, if you want the number edit box labeled .... .&quot;

The cell reference O15 in the formula example actually refers to the initial/result cell for the text edit box labeled &quot;Instrument&quot; not the number edit box labeled &quot;Dues Paid.&quot;

The formula example reads:

  =SET.VALUE(O15,40.05)

This formula should read:

  =SET.VALUE(O13,40.05)