Microsoft KB Archive/175996

= XL98: UserForm Changes Position When Using a RefEdit Control =

Article ID: 175996

Article Last Modified on 9/11/2002

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q175996



SYMPTOMS
In Microsoft Excel, the top and left positions of the UserForm (custom dialog box) change when you select a range of cells using a RefEdit control.



CAUSE
This problem occurs when you create a UserForm that has a RefEdit control and then do one of the following:


 * You select a range of cells using the RefEdit control. -or-


 * You click the button of the RefEdit control.



STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.



MORE INFORMATION
A RefEdit control is similar in behavior and appearance to an Edit Box control with an InputType property that you set to xlReference. (The Edit Box control is available in Excel 5.0 on the Forms toolbar in dialog sheets.) The RefEdit control differs from an Edit Box control in that the RefEdit control contains a button that allows you to collapse the UserForm to easily select a cell range.

Additional query words: XL98 vbe

Keywords: kbbug kbprogramming kbpending KB175996

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.