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