View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_7_] Bob Phillips[_7_] is offline
external usenet poster
 
Posts: 1,120
Default Nulling a option button

Keri,

Do you mean

If Range("A1").value = "TRUE" Then
Activesheet.OptionButton1.Enabled = False
Activesheet.OptionButton2.Enabled = False
Else
Activesheet.OptionButton1.Enabled = True
Activesheet.OptionButton2.Enabled = True
End If

--
HTH

-------

Bob Phillips
"Keri" wrote in message
...
I would like to "NULL" a group of option buttons if a cell
in the work book is "TRUE" and "ENABLE" a group of option
buttons if that cell is "FALSE" Any ideas??

Keri