Hello,
I am struggling with the code to make my combobox appear and disappear.
I want to make my combobox appear when N= 1.
For all other cases It has to be disappeared.
I have made my code like this:
Private Sub Combobox_visible()
If Range("N6").Value = 1 Then
ComboBox1.Visible = True
Else
ComboBox1.Visible = False
End If
End If
End Sub
But it doesn't work, itstays visible all the time. Can someone please help me???
I cant upload my excel here?
Thank you!!
I am struggling with the code to make my combobox appear and disappear.
I want to make my combobox appear when N= 1.
For all other cases It has to be disappeared.
I have made my code like this:
Private Sub Combobox_visible()
If Range("N6").Value = 1 Then
ComboBox1.Visible = True
Else
ComboBox1.Visible = False
End If
End If
End Sub
But it doesn't work, itstays visible all the time. Can someone please help me???
I cant upload my excel here?
Thank you!!