XL Err Msg: EditBox Does Not Have LockedText PropertyLast reviewed: February 4, 1998Article ID: Q172920 |
The information in this article applies to:
SYMPTOMSWhen you record a macro to toggle the Lock Text check box of an edit box on a dialog sheet, you may receive the following error message when you run te macro:
Run-time error '1000': EditBox does not have LockedText propertyIf you click Goto on the Macro Error dialog box, a line similar to the following is selected:
.LockedText = True CAUSEEven though Microsoft Excel records the property, there is no LockedText property for the EditBox object in the Microsoft Excel Object Library.
WORKAROUNDYou must clear the Lock Text check box for an edit box manually. To do this, follow these steps:
STATUSMicrosoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in Microsoft Excel 97 for Windows and Microsoft Excel 98 Macintosh Edition.
MORE INFORMATIONFor additional information, please see the following article in the Microsoft Knowledge Base:
ARTICLE-ID: Q130108 TITLE : XL Err Msg: Unable to Set the Text Property of Editbox Class |
Additional query words: 5.00 5.00a 5.00c 7.00 7.00a XL5 XL7
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |