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

Hi hoyos

add following to your code

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

Regards
Om

"hoyos" wrote:

> 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

Many thanks OM that works well.

"om" wrote:

> Hi hoyos
>
> add following to your code
>
> Private Sub UserForm_Initialize()
> ComboBox7.Visible = False
> Label106.Visible = False
> End Sub
>
> Regards
> Om
>
> "hoyos" wrote:
>
> > 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