XL2000: Run-Time Error 1004 Setting Focus to Dialog Sheet (213668)
The information in this article applies to:
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.
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
| Modification Type: | Minor | Last Reviewed: | 10/11/2006 |
|---|
| Keywords: | kbbug kberrmsg kbpending KB213668 |
|---|
|