Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Grouping Option Boxes?
I've got a form that can be filled out in Excel, or printed out and filled in with pen. I'm using the "Option Box" from the Forms toolbar, but they are all linked, i.e., only one Option Box can be checked at any given time. How can I differentiate among groups of Option Boxes on the same page? I have tried using the Group Box to no avail. Thanks! ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Grouping Option Boxes?
rubber-banding a group box around each set of option buttons does what you
describe. -- Regards, Tom Ogilvy "Drewski" wrote in message ... I've got a form that can be filled out in Excel, or printed out and filled in with pen. I'm using the "Option Box" from the Forms toolbar, but they are all linked, i.e., only one Option Box can be checked at any given time. How can I differentiate among groups of Option Boxes on the same page? I have tried using the Group Box to no avail. Thanks! ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Grouping Option Boxes?
Change the GroupName property of the control - all options with the same
name are linked together. The group box (of frame) will organise the controls together unless you change the GroupName property. Cheers Nigel "Drewski" wrote in message ... I've got a form that can be filled out in Excel, or printed out and filled in with pen. I'm using the "Option Box" from the Forms toolbar, but they are all linked, i.e., only one Option Box can be checked at any given time. How can I differentiate among groups of Option Boxes on the same page? I have tried using the Group Box to no avail. Thanks! ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Grouping Option Boxes?
Tom, I think Drewski wants to ungroup them? In which case my suggestion
would be to change the GroupName property of the control. Cheers Nigel "Tom Ogilvy" wrote in message ... rubber-banding a group box around each set of option buttons does what you describe. -- Regards, Tom Ogilvy "Drewski" wrote in message ... I've got a form that can be filled out in Excel, or printed out and filled in with pen. I'm using the "Option Box" from the Forms toolbar, but they are all linked, i.e., only one Option Box can be checked at any given time. How can I differentiate among groups of Option Boxes on the same page? I have tried using the Group Box to no avail. Thanks! ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Grouping Option Boxes?
Guess you didn't read the post Nigel.
I'm using the "Option Box" from the Forms toolbar, Optionbuttons from the forms toolbar don't have a groupname property. How can I differentiate among groups of Option Boxes on the same page? So he wants to group them, not ungroup them. A group box is used to do that with the forms controls. -- Regards, Tom Ogilvy Nigel wrote in message ... Tom, I think Drewski wants to ungroup them? In which case my suggestion would be to change the GroupName property of the control. Cheers Nigel "Tom Ogilvy" wrote in message ... rubber-banding a group box around each set of option buttons does what you describe. -- Regards, Tom Ogilvy "Drewski" wrote in message ... I've got a form that can be filled out in Excel, or printed out and filled in with pen. I'm using the "Option Box" from the Forms toolbar, but they are all linked, i.e., only one Option Box can be checked at any given time. How can I differentiate among groups of Option Boxes on the same page? I have tried using the Group Box to no avail. Thanks! ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Grouping Option Boxes?
OOps! - sorry about that....... but its worth remembering to add the option
controls to the frame after the frame was created not before. Cheers Nigel "Tom Ogilvy" wrote in message ... Guess you didn't read the post Nigel. I'm using the "Option Box" from the Forms toolbar, Optionbuttons from the forms toolbar don't have a groupname property. How can I differentiate among groups of Option Boxes on the same page? So he wants to group them, not ungroup them. A group box is used to do that with the forms controls. -- Regards, Tom Ogilvy Nigel wrote in message ... Tom, I think Drewski wants to ungroup them? In which case my suggestion would be to change the GroupName property of the control. Cheers Nigel "Tom Ogilvy" wrote in message ... rubber-banding a group box around each set of option buttons does what you describe. -- Regards, Tom Ogilvy "Drewski" wrote in message ... I've got a form that can be filled out in Excel, or printed out and filled in with pen. I'm using the "Option Box" from the Forms toolbar, but they are all linked, i.e., only one Option Box can be checked at any given time. How can I differentiate among groups of Option Boxes on the same page? I have tried using the Group Box to no avail. Thanks! ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
option button grouping | Excel Worksheet Functions | |||
How do i create a value for check boxes or option boxes | Excel Discussion (Misc queries) | |||
Grouping combo boxes | Excel Worksheet Functions | |||
grouping of option buttons | Excel Discussion (Misc queries) | |||
Grouping Option Buttons | Excel Programming |