Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi all
I'm trying to run the following macro to reset the entries in option buttons and check boxes. Sub ResetSelection() For Each shp In ActiveSheet.Shapes For Each grp In shp.GroupItems If TypeOf grp.DrawingObject.Object Is MSforms.OptionButton Or TypeOf grp.DrawingObject.Object Is MSforms.CheckBox Then grp.DrawingObject.Object.Value = False End If Next grp Next shp End Sub This works fine for the shapes that are grouped objects, however shp.groupitems gives an error if shp is not a group. What is the correct syntax to perform a check on shp, e.g. something like: if shp.type = groupedobject then... Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ShemeColor Shape/Group | Excel Programming | |||
Change order in a multi-shape group? | Excel Programming | |||
text in shape group | Excel Programming | |||
Get the name of a group given the reference to a shape within the group | Excel Programming | |||
Reference oleobject within shape group | Excel Programming |