Excel: Custom Number Format May Cause Dialog Box Error

Last reviewed: November 2, 1994
Article ID: Q64346

SUMMARY

In a Microsoft Excel dialog box definition table, if a cell in the Initial/Result column for a number or integer edit box is formatted with a custom number format that includes a text character, a dialog box error will result.

The following error message

   Error in dialog at MacroSheetName!Cell_Reference

will be returned, followed by a macro error at the cell containing the DIALOG.BOX function.

Text characters cannot be displayed in a number or integer edit box. To display a number in a custom format that includes a text character in a dialog box, change the item number of the edit box from either a 7 to a 6, or an 8 to a 6, making it a text edit box.

Note: These numbers will become text strings and cannot be used in calculations.

KBCategory: kbother
KBSubcategory:
Additional reference words: noupd

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 2, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.