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

SUMMARY

Microsoft Excel Version 4.0

On page 274 of the version 4.0 "Microsoft Excel User's Guide 2," in the "Setting Initial Values and Returning Values" 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 "Integer edit box"; it should refer to the "Number edit box." 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 "Microsoft Excel User's Guide" on the following pages:

• On page 634 of the version 3.0 "Microsoft Excel User's Guide" for Windows.

  -and-

• On page 629 of the version 3.0 "Microsoft Excel User's Guide" for the Macintosh.

MORE INFORMATION

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

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

The formula example reads:

   =SET.VALUE(O15,40.05)

   =SET.VALUE(O13,40.05)

REFERENCES

"Microsoft Excel User's Guide 2," version 4.0, pages 273-279

"Microsoft Excel User's Guide," version 3.0 for Windows, pages 633-638

"Microsoft Excel User's Guide," version 3.0 for the Macintosh, pages 629-634