Try this:

If CheckBox1.Value Then
mg(1,3).Value = "X"
End If

Patrick Simonds wrote:
The code below enters True when the CheckBox is checked, and False when it
is not. Is there any way to have it place an X when the checkbox is checked
and nothing when it is not checked?

rng(1, 3).Value = CheckBox1.Value