Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I believe I have figured it out ... after much searching.
ActiveSheet.Shapes(PictName).ParentGroup.Name gives me the name of the group the shape belongs to. Thanks -----Original Message----- Sorry, not sure how to do that. Is this a real group that Excel recognizes, or just what you consider to be a group? What were the mechanics of the grouping process? -- Vasant "David Cuthill" wrote in message ... I'm sorry - I am refering to a picture or a label that is inserted on a worksheet not a user form. The picture and label form a grouped image and I want to determine the group name if one of the grouped items is selected. David -----Original Message----- If the controls are grouped using Frame controls, you can use the Parent property of the control to return the Frame that the control belongs to. Or, depending on how you have formed the groups, you can use the GroupName property of the control. -- Vasant "David Cuthill" wrote in message ... If I select an item (picture or textbox) of a group how do I determine what the group or group name the item is a member of? David . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
current time member | Excel Discussion (Misc queries) | |||
Member database question! | Excel Worksheet Functions | |||
condition - member of a group | Excel Discussion (Misc queries) | |||
Is member of an array? | Excel Programming | |||
Is it possible to set a class member to be another class member? | Excel Programming |