![]() |
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 |
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