rng.Offset(-1, 6).value to work with CheckBox value

[Corey]

Code line:
If rng.Offset(-1, 6).Value = Sheets("Inspections").Range("T13").Value Then
Range("S13").Value = "TRUE" Else Range("S13").Value = "FALSE"

The offset is correct.(-1,6)

I have in Sheets("Inspections").Range("T13") a text value of "AAA"
and in
Sheets("Inspections").Range("S13") a text value of "FALSE" . This value is
the linked cell for the Checkbox.

I have a total of 4 checkboxes. Linked cells are "S13:S16", and i have 4
text values in the range of "T13:T16" that co-incide wit the linked cells to
give a texct value other than a TRUE or FALSE value.

In the baove code i get a Ticke box when the text value in T13 = "AAA",
which is CORRECT, the Tick is placed in the checkbox because of the
range("S13").value = TRUE.

BUT,

If i change the text value in "T13" to something else, say "ZZZ", i STILL
get a checkBox with a Tick.


How can i rectify this so i can input values and change the check/uncheck
values of the checkboxes ?

Corey....

 

[Mike Fogleman]

It worked for me using both types of checkboxes, Forms and Control.

Mike F