Checkbox problem
 

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

Checkbox problem
 

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 o
identifiers, a start and a finish, that in this case are the same as w
are identifying a single cell.

HTH

Dominic

--
dominic
-----------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...fo&userid=1893
View this thread: http://www.excelforum.com/showthread.php?threadid=47164