OPTION BUTTON QUESTION

slangbert · Apr 5th, 2002, 09:36 AM

I have created a number of option buttons in a column. buttons are yes and no. the problem i have is that if you select yes for the first set, when you select yes or no for the next set, it automatically clears the yes button from the first set. i amm trying to get each pair of buttons to work independently of the other sets. any help sure is appreciated.

lenze · Apr 5th, 2002, 09:41 AM

You will need to group them to make each set independent. The method is different depending on which type of option button you are using. Are you using option buttons from the Form Toolbar or the Control Toolbar? If from the form toolbar,you need to draw a frame (it's called a group box) around each set. If from the control toolbar, you can assign a group in the properties dialog

slangbert · Apr 5th, 2002, 10:15 AM

thanks for the quick reply. I used the FORMS toolbar. I can group 2 buttons together, however, under properties, i dont have any option to "group the items". All it shows is:move and size with cells etc... I can't seem to get 2 of the buttons to work independently of the others. any other tips? thanks

lenze · Apr 5th, 2002, 10:21 AM

You will not have the property option for option buttons from the Forms toolbars. You must use the group box from the Forms toolbar. One important point. Each option button in a group must be COMPLETELY within the group box for the grouping to take effect. This includes the label part of the option button.

slangbert · Apr 5th, 2002, 10:27 AM

THANK YOU VERY MUCH!!! IT WORKS!!!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 5th, 2002, 09:36 AM	#1
slangbert New Member Join Date: Apr 2002 Posts: 7	I have created a number of option buttons in a column. buttons are yes and no. the problem i have is that if you select yes for the first set, when you select yes or no for the next set, it automatically clears the yes button from the first set. i amm trying to get each pair of buttons to work independently of the other sets. any help sure is appreciated.

Apr 5th, 2002, 09:41 AM	#2
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	You will need to group them to make each set independent. The method is different depending on which type of option button you are using. Are you using option buttons from the Form Toolbar or the Control Toolbar? If from the form toolbar,you need to draw a frame (it's called a group box) around each set. If from the control toolbar, you can assign a group in the properties dialog

Apr 5th, 2002, 10:15 AM	#3
slangbert New Member Join Date: Apr 2002 Posts: 7	thanks for the quick reply. I used the FORMS toolbar. I can group 2 buttons together, however, under properties, i dont have any option to "group the items". All it shows is:move and size with cells etc... I can't seem to get 2 of the buttons to work independently of the others. any other tips? thanks

Apr 5th, 2002, 10:21 AM	#4
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	You will not have the property option for option buttons from the Forms toolbars. You must use the group box from the Forms toolbar. One important point. Each option button in a group must be COMPLETELY within the group box for the grouping to take effect. This includes the label part of the option button.

Apr 5th, 2002, 10:27 AM	#5
slangbert New Member Join Date: Apr 2002 Posts: 7	THANK YOU VERY MUCH!!! IT WORKS!!!