Using GroupName

[Guest]

Hi
Is it possible to use the groupname to be able to make the option buttons
visible on a worksheet rather than the individual optionbutton names.

ie
optCheck, optHold, optNew
groupname = Testing

is there away to do the following

groupname(testing).visible = true

which makes the 3 option buttons visible.

Thanks
Noemi

 

[Guest]

To the best of my knowledge... No. You could write code to loop through all
of the option buttons in the frame but that would be a lot more work than
just coding the 3 buttons themselves...

 

[Tom Ogilvy]

No, but you could do

for each ole in OleObjects
if typeof ole.Object is MSForms.OptionButton then
if lcase(ole.Object.GroupName) = "testing" then
ole.visible = False
end if
end if
Next

 

[Guest]

Hi Tom
Is there a way of also making it visible as a group.

Thanks
Noemi

 

[Dave Peterson]

ole.visible = True
?????

Hi Tom
Is there a way of also making it visible as a group.

Thanks
Noemi

 

[Tom Ogilvy]

That would have been my guess as well.

 

[Dave Peterson]

You have a very dry wit (just like your martinis???).