Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Option Button code not working
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
option button ? | Excel Discussion (Misc queries) | |||
Option Button | Excel Worksheet Functions | |||
keep source formatting is not an option in paste option button | Excel Discussion (Misc queries) | |||
Option Button Help | Excel Discussion (Misc queries) | |||
option button | Excel Discussion (Misc queries) |