View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Grouping radio buttons?

hi
radio button are sometimes call options buttons and yes, they do have a
group property which you have to go to and type in the name of the group it
belongs to.
see this site for a short tutorial.

http://www.functionx.com/excel/artic...diobuttons.htm

regards
FSt1

"Fabz" wrote:

I am writing a ComAddIn using VSTO (Excel 2007, Visual Studio/VSTO 2008).
Now I want to add some radio buttons
(Microsoft.Office.Tools.Excel.Controls.RadioButton ) on my sheet. However, I
just don't get the idea and it's hard to find any useful information. For
any reason the radio buttons don't seem to be connected, this means when
selecting one of them, the others will not be unselected.

1. Why is this so? And thus, how do I group the radio buttons? Do I
explicitly have to use GroupBox or Panel or something alike? Or is there
some kind of GroupName-Property I can use (I cannot find one)? I also tried
using Controls.AddRadioButton(myRange, myRadioButtonName) dynamically, but
this lead to the same problem.

2. Assuming I indeed have to use some kind of GroupBox, the radio buttons
seem to be positioned according to the GroupBox itself. But I do not want
GroupBox to define their position but the cells into which I originally
positioned the radio buttons. Is there a way to do this?

Thanks for your help.


.