View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Elkar
 
Posts: n/a
Default Can I an option button in two groups?

You should be able to accomplish this by adding code to your (N/A) option
button to clear the contents of all the linked cells for your entire option
groups including itself. Something like this:


Private Sub OptionButton10_Click()

Range("A1:A10").Value = ""

End Sub


HTH,
Elkar

"Jono" wrote:

I have two groups of option buttons one for an interface (RS232, RS422, etc.)
and another for a protocol (Standard, EWIS, etc.) I would like to have an
option button (N/A) that deselects both of these groups and is deselected
when selecting a button in either of these groups. In these two groups if one
group has something selected the other group will also have something
selected.