How to show and hide a worksheet when we select an element of combined combo (list activex) ?

[francois.lemarie]

Hello,

I am working with the following file :
http://depositfiles.com/es/files/qx3unewrn

I have a combolist (ListBox but not in a form, in Activex) with various choices. I want a worksheet to be shown only if I choose "Closed - won". It must be hidden otherwise.

I trew a code but the worksheet is hidden all the time.

What's wrong ? Anyone could be so kind to give me the good code ?

Private Sub ComboStatusopp_Change()
If ComboStatusopp.Value = Closed - won Then
Worksheets("CloseInfo").Visible = True
Else
Worksheets("CloseInfo").Visible = False
End If

End Sub

Thanks a lot

 

[MickG]

Hi, Try:-

Private [COLOR="Navy"]Sub[/COLOR] ComboStatusopp_Change()
[COLOR="Navy"]If[/COLOR] ComboStatusopp.Value = "Closed - won" [COLOR="Navy"]Then[/COLOR]
    Sheets("CloseInfo").Visible = True
[COLOR="Navy"]Else[/COLOR]
    Sheets("CloseInfo").Visible = False
[COLOR="Navy"]End[/COLOR] If
[COLOR="Navy"]End[/COLOR] [COLOR="Navy"]Sub[/COLOR]

Regards Mick

 

[francois.lemarie]

Hi MickG. It works very well for me.

Thanks a lot.