Check box if cell value is X

[Lizabeta]

I've seen lots of posts about updating a cell value based on whether or not a checkbox is marked or unmarked.

Is there a way to do the opposite?

If A1 = X then checkbox = true/checked?

 

[Sahak]

Hi Lizabeta,

Try this:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Range("A1") = "X" Then
        CheckBox1.Value = True
    Else
        CheckBox1.Value = False
    End If
End Sub

 

[Lizabeta]

So if I had more than one check box, I would just put the code (attached to the indivdual check box) and substitute Checkbox1.Value with the number of the next box... Like... Checkbox2.Value for the second, Checkbox3 for the third... Correct?

And then for each checkbox, the code will look in the cell and I could replace the "X" with... "Spanish" "English" or whichever one that box is testing for, also correct?

For instance:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Range("A1") = "Spanish" Then
        CheckBox2.Value = True
    Else
        CheckBox2.Value = False
    End If
End Sub

 

[Lizabeta]

Okay... so it's not each indivdual box... you add an additional IF statement after the End If, Like this:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Range("A1") = "Spanish" Then
        CheckBox1.Value = True
    Else
        CheckBox1.Value = False
    End If
    If Range("A1") = "Vietnamese" Then
        CheckBox2.Value = True
    Else
        CheckBox2.Value = False
    End If
End Sub

This works wonderfully! Thank you!

 

[Sahak]

What do you mean?

 if I had more than one check box

All CheckBox values (for example CheckBox5, CheckBox2, CheckBox4 … ) should be depended from one cell value (for example A1)? Or
For example CheckBox2 from A8, CheckBox5 from A3, ....?

 

[Lizabeta]

Cell A1 returns the value of which language is being used (Through a whole 'nother INDIRECT formula, based on the sheet name)
So every box will be looking at the same cell.

The code in my previous reply, where CheckBox1 and CheckBox2 both looked in A1 and tested for the language works perfectly! If I change A1, the check mark pops over to the correct box.

 

[Sahak]

Yes, your cod is OK