Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Nulling a option button
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Option Button Help PLEASE!! | Excel Worksheet Functions | |||
keep source formatting is not an option in paste option button | Excel Discussion (Misc queries) | |||
Option Button Help | Excel Worksheet Functions | |||
Option Button | Excel Discussion (Misc queries) | |||
VBA - Option Button | Excel Programming |