Knowledge Base

Run-Time Error 1004 Setting Focus to Dialog Sheet

Article ID: 180354

Article Last Modified on 10/10/2006

Microsoft Excel 97 Standard Edition
Microsoft Excel 98 for Macintosh

This article was previously published under Q180354

SYMPTOMS

If you run a Microsoft Visual Basic for Applications macro that attempts to set the focus to a Microsoft Excel 5.0 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 this to be a problem in the Microsoft products listed at the beginning of this article.

Additional query words: XL97 XL

Keywords: kbbug KB180354