Checkbox problem

[Patrick Simonds]

Not sure why the following code returns an Object Required Error:

If CheckBox1.Value = True Then
rng(1, 6) = "Exempt"
End If

What I want to have happen is for the word Exempt to be placed in the rng(1,
6) when there is a check in Checkbox1

[dominicb]

Good morning Patrick Simmonds

Does this help:

Range(Cells(1, 6), Cells(1, 6)) = "Exempt"

Range is the command to identify a range, but you need two lots of identifiers, a start and a finish, that in this case are the same as we are identifying a single cell.

HTH

DominicB