Microsoft KB Archive/115312

= Control Method of Sheet Class Failed with Grouped Control =

Article ID: 115312

Article Last Modified on 10/11/2006

-

APPLIES TO


 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel 5.0c
 * Microsoft Excel 5.0 Standard Edition

-



This article was previously published under Q115312





SYMPTOMS
In a Visual Basic module in Microsoft Excel, when you use the Value property to set the property of a control, or return the property of a control contained on a worksheet or dialog sheet, you receive the following error message if the control is grouped

Run-time error '1004':

method of Worksheet class failed

where is the name of the control such as OptionButtons, or CheckBoxes.

Note that in the error message may also be DrawingObjects, if you use the DrawingObjects method to return the control object.



CAUSE
This behavior is by design in Microsoft Excel. When you select multiple controls, and group them, the controls are now treated as a single object. This makes it easier to move the controls, because they move together, but you can no longer modify the properties of an individual control.

Note that when you select a grouped object, such as a check box, and choose Object from the Format menu, there is no Control tab to set the value of the check box to checked or mixed.



WORKAROUND
To avoid this behavior, you must ungroup the control before you can set the properties of an individual control, such as setting the value of an Option Button to selected, or the value of a Check Box to clear (unchecked).



MORE INFORMATION
For more information about verifying the value of a check box, query on the following words in the Microsoft Knowledge Base:

value and check and box and xlon

