Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default Using GroupName

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

Tom Ogilvy wrote:

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


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
GroupName for OptionButton Shawn G. Excel Programming 3 July 6th 06 04:35 PM
How to referance a GroupName Garry[_7_] Excel Programming 3 October 5th 04 01:24 PM
GroupName Paul Excel Programming 2 December 4th 03 11:33 AM


All times are GMT +1. The time now is 09:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"