Forum Discussion
If there is a certain Text -> CheckBox disappear
Hello, I would like to ask you if you know a function that could allow this : I have a dropdown list, I use a ComboBox, and depending on what element you have selected, texts appear/disappear. I h...
I suppose you're using Develop->Controls->Insert->Combo/CheckBox,
And I think you need use VBA.
(1) Create a macro, where "H7" is the cell linked to ComboBox, "2" is the value you want to blank the CheckBox. Modify the names according to yours.
Sub Macro1()
If Range("H7") = 2 Then
Sheets("Sheet2").CheckBoxes("Check Box 4").Visible = False
Else
Sheets("Sheet2").CheckBoxes("Check Box 4").Visible = True
End If
End Sub
(2) Right click the ComboBox and assign this macro to it.
And I think you need use VBA.
(1) Create a macro, where "H7" is the cell linked to ComboBox, "2" is the value you want to blank the CheckBox. Modify the names according to yours.
Sub Macro1()
If Range("H7") = 2 Then
Sheets("Sheet2").CheckBoxes("Check Box 4").Visible = False
Else
Sheets("Sheet2").CheckBoxes("Check Box 4").Visible = True
End If
End Sub
(2) Right click the ComboBox and assign this macro to it.