Hide Check Box base on another cells data

[MitchOwen]

Hi I looked at other threads that cover this but can't seem to get any of their suggestions to work.

I have a cell K14 that has a list of 3 options:

Pre_Finished
_2_Pac
Veneer

I have a check box that i want to hide when "Pre_Finished" is selected but available for checking when "_2_Pac" or "Veneer" are selected.

My coding knowledge is extremley basic.

Thank you for your help!

 

[KOKOSEK]

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Range("K14")) Is Nothing Then
        If Target.Value = "Pre_Finished" Then
            ActiveSheet.Shapes.Range(Array("Check Box 1")).Visible = False
        Else
            ActiveSheet.Shapes.Range(Array("Check Box 1")).Visible = True
        End If
    End If
End Sub

 

[MitchOwen]

Thank you KOKOSEK

I opened VBA (Alt+F11) and insert a new module and pasted in your code but nothing happens? Do i need to record a macro first?

 

[KOKOSEK]

you can paste this code straight into Sheet code not into Module.

 

[MitchOwen]

Thank you KOKOSEK

I think i have done it right but the check box is not hiding. My check box is defined "Checkbox2" and i updated that info in the code.

My steps are:

1. right click on the sheet and select view code
2. paste your code and update to "Checkbox2"
3. save and close

Is this right? I really appreciate your guidance.

 

[KOKOSEK]

You have written:

[COLOR=#333333]I have a cell K14 that has a list of 3 options:[/COLOR]

so I expect that in K14 is dropdown list.