| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Control Checkboxes based on Option Button result
Hello All
I have two option buttons in a spreadsheet. When one of these option buttons is selected, I'd like to disable several control checkboxes. How can I accomplish this? Thanks. BJ |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disable Control Checkboxes based on Option Button result
Private Sub OptionButton1_Click()
If OptionButton1.Value = True Then CheckBox1.Enabled = False End If End Sub "BJ" [No Spam Please] wrote in message ... Hello All I have two option buttons in a spreadsheet. When one of these option buttons is selected, I'd like to disable several control checkboxes. How can I accomplish this? Thanks. BJ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disable Control Checkboxes based on Option Button result
if I'm disabling multiple checkboxes are the additional conditions just added
or is there additional syntax required? I added the multiple lines and nothing is working - i.e. the checkboxes are not being disabled. Thanks. e.g., Private Sub OptionButton1_Click() If OptionButton1.Value = True Then CheckBox1.Enabled = False CheckBox2.Enabled = False End If "dman" wrote: Private Sub OptionButton1_Click() If OptionButton1.Value = True Then CheckBox1.Enabled = False End If End Sub "BJ" [No Spam Please] wrote in message ... Hello All I have two option buttons in a spreadsheet. When one of these option buttons is selected, I'd like to disable several control checkboxes. How can I accomplish this? Thanks. BJ |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disable Control Checkboxes based on Option Button result
Thanks dman
I think I figured it out ... appreciate the help. BJ "dman" wrote: Private Sub OptionButton1_Click() If OptionButton1.Value = True Then CheckBox1.Enabled = False End If End Sub "BJ" [No Spam Please] wrote in message ... Hello All I have two option buttons in a spreadsheet. When one of these option buttons is selected, I'd like to disable several control checkboxes. How can I accomplish this? Thanks. BJ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| reset ALL checkboxes (created with control toolbar) with the click of ONE BUTTON | Excel Programming | |||
| need help on how to grey out one option button in one group box based on the selection of another option button in another group box | Excel Programming | |||
| enable/disable checkboxes based on other data | Excel Programming | |||
| Control Cell Link for Option Button based on value in a cell | Excel Programming | |||
| Control Cell Link for Option Button based on value in a cell | Excel Programming | |||
Linear Mode
