CheckBox Ticked, ComboBoxBox visible?

[hoyos]

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

 

[om]

Hi hoyos

add following to your code

Private Sub UserForm_Initialize()
ComboBox7.Visible = False
Label106.Visible = False
End Sub

Regards
Om

 

[hoyos]

Many thanks OM that works well.

Hi hoyos

add following to your code

Private Sub UserForm_Initialize()
ComboBox7.Visible = False
Label106.Visible = False
End Sub

Regards
Om