View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default Option Button code not working

That vent won't kick in if the second is clicked, so you need similar code
in its click event.

--
__________________________________
HTH

Bob

"Sara" wrote in message
...
I am trying to use this code to hide/unhide text and background color. For
some reason it is not working. I want to have two option buttons and if 1
is
not checked the font and background should disappear. It's not happening
when
I click on Option Button 2?

Private Sub OptionButton1_Click()

If OptionButton1.Value = True Then
Me.Range("Y27:AA27").Font.Color = RGB(0, 0, 0)
Else
Me.Range("Y27:AA27").Font.Color = RGB(255, 255, 255)
End If

End Sub