Microsoft KB Archive/213668

= XL2000: Run-Time Error 1004 Setting Focus to Dialog Sheet =

Article ID: 213668

Article Last Modified on 10/11/2006

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q213668





SYMPTOMS
If you run a Microsoft Visual Basic for Applications macro that attempts to set the focus to a Microsoft Excel 5 dialog sheet, you may receive the following error message:

Run-time error '1004': Unable to set the Focus property of the DialogSheet class



CAUSE
This problem may occur if the name of the control in the dialog sheet to which you are setting the focus contains any non-alphanumeric characters, such as hyphens (-), apostrophes ('), or colons.

Example: ThisWorkbook.DialogSheets("Dialog1").Focus = "true-false"



WORKAROUND
To prevent this problem from occurring, make sure that the names of controls in your dialog sheets contain only the following characters:

A-Z

a-z

0-9

Spaces

Underscore characters (_)

If other characters are contained within the name of a control, problems may occur when you use a macro that refers to the control.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Additional query words: XL2000

Keywords: kbbug kberrmsg kbpending KB213668

-

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

© Microsoft Corporation. All rights reserved.