show/hide checkbox according to listbox

[Masterofmayhem]

Hi!

I'm new to the forum and VBA, so I need a bit of help.

Example:

A1 has a data validation list compirising of choices in cells B1,B2,B3. Easy.

C1 has a checkbox made through the developer tab. I want this to only show up if A1 has the value of cell B2.

This propably is simple, but as I have no previous experience of VBA, I am unable to modify any of the codes I have already found to suit my need.
Thanks for your assistance and time!

 

[Masterofmayhem]

I forgot to add that while hiding a checkbox is nice, it would be even better to hide and disable it when not ín use.

 

[Masterofmayhem]

Nevermind, figured it out... For anyone who needs to know this, this is how it goes:

1st: the checkbox needs to be created through ActiveX controls.

2nd: once the data validation list is done, the following code needs to be places in the worksheet code:

Private Sub Worksheet_Change(ByVal Target As Range)
Select Case Range("A1")

Case "a"
CheckBox2.Visible = True
CheckBox1.Visible = False

Case "b"
CheckBox2.Visible = False
CheckBox1.Visible = True

End Select
With Selection
CheckBox1.LinkedCell = "F2"
CheckBox2.LinkedCell = "F3"
End With
End Sub

In my worksheet the checkboxes are placed on top of each other, so that only one is used at any given time. In the full code, I added CheckBox#.Value = False to both data validation choices to always zero the checkboxes to unselected states.

If the checkboxes should link to the same cell, then the data can be told apart by adding a cell with double IF or an AND function. It is much simpler to have them linked to separate cells though =)