Excel: Dialog Box Incorrect When Created Using Dialog Editor

Last reviewed: November 2, 1994
Article ID: Q61839

SUMMARY

When a quotation mark is used to begin a text entry in a custom dialog box created with the Dialog Editor and a second quotation mark does not complete that text entry, the dialog box may not appear correctly in Microsoft Excel.

This problem occurs because Excel delimits cells with tabs except when a field is surrounded by quotation marks. If the text field begins with a quotation mark, Excel will search for a closing quotation mark before parsing to the next cell.

To correct this problem, remove the opening quotation mark from the text field before pasting the custom dialog box into Excel. Once the data is in Excel, add the quotation mark to the text field in the dialog box definition table.


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.