ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Nulling a option button (https://www.excelbanter.com/excel-programming/298097-nulling-option-button.html)

Keri[_2_]

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

Bob Phillips[_7_]

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





All times are GMT +1. The time now is 10:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com