View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Hoyos Hoyos is offline
external usenet poster
 
Posts: 74
Default CheckBox Ticked, ComboBoxBox visible?

I have the following code below only works when the userform is displayed. If
I un-check the checkbox which then hides a combobox. If then close the
userform and reopen it again the combobox is visible even though the checkbox
is not ticked.
How can I get over this problem?

Private Sub CheckBox62_Change()
If CheckBox62.Value = True Then
ComboBox7.Visible = True
Label106.Visible = True
Else
CheckBox62.Value = False
ComboBox7.Visible = False
Label106.Visible = False
End If
End Sub