Thread: Using GroupName
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Using GroupName

That would have been my guess as well.

--
Regards,
Tom Ogilvy


"Dave Peterson" wrote in message
...
ole.visible = True
?????



Noemi wrote:

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

Thanks
Noemi

"Tom Ogilvy" wrote:

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

--
Regards,
Tom Ogilvy


"Noemi" wrote in message
...
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




--

Dave Peterson