Microsoft KB Archive/64657

{| = Excel: OK Button in Dialog Box Does Not Return a &quot;True&quot; Value =
 * width="100%"|

Last reviewed: November 2, 1994

Article ID: Q64657

SUMMARY
Page 174 of the &quot;Microsoft Excel Functions and Macros&quot; version 2.2 manual incorrectly states that when an OK button is clicked in a custom dialog box, a value of &quot;True&quot; is returned to the macro sheet.

Clicking an OK button actually returns a number value to the macro sheet. The number is equal to the position of the OK button in relation to all other items in the Item Number column of the dialog box definition table.

For example, if there are seven different items in the Item Number column of the dialog box definition table and the OK button is the fifth in the list, clicking the OK button will return a 5 to the cell on the macro sheet containing the DIALOG.BOX function.
 * }