#1   Report Post  
Posted to microsoft.public.excel.misc
umba-sr
 
Posts: n/a
Default group option buttons

Hi,

I have a sheet in which I set some option buttons for 5 matters. That means
that I can click and choose only one of those 5. But, now I have 3 more on a
same sheet, bellow these five, and thay are not related to those 5 above, and
after putting option buttons for those three, I cannot choose among those
three without loosing the pick in above 5. I tried grouping them, but it
seems to have no effect.

Help please.
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default group option buttons

If they are optionbuttons from the Forms toolbar, you need to put them in a
frame. If they are from the controls toolbox, set the GroupName property.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"umba-sr" wrote in message
...
Hi,

I have a sheet in which I set some option buttons for 5 matters. That

means
that I can click and choose only one of those 5. But, now I have 3 more on

a
same sheet, bellow these five, and thay are not related to those 5 above,

and
after putting option buttons for those three, I cannot choose among those
three without loosing the pick in above 5. I tried grouping them, but it
seems to have no effect.

Help please.



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
Deleting option buttons jzemanek Excel Discussion (Misc queries) 2 August 20th 05 12:04 AM
Using 'Option Buttons' Julian Excel Discussion (Misc queries) 3 August 17th 05 07:36 PM
Second option button disappears when I make another column Monique Excel Worksheet Functions 0 March 9th 05 09:57 PM
Group buttons from the forms toolbar GregR Excel Discussion (Misc queries) 1 December 7th 04 01:25 AM
Can I use more than one set of option buttons in a worksheet? Ray Excel Worksheet Functions 2 November 22nd 04 03:37 PM


All times are GMT +1. The time now is 02:52 PM.

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

About Us

"It's about Microsoft Excel"