View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TDC TDC is offline
external usenet poster
 
Posts: 14
Default If then to hide a combo box

I am trying to make a combo box appear if a value is greater than 1 or hide
if it is not. Below is what I have, but it does not work. Suggestions?

Private Sub test_change()
If Range("AJ19").Value 1 Then
UserForm1.ComboBox1.Visible = True
Else
UserForm1.ComboBox1.Visible = False
End If
End Sub