The same logic, but you wouldn't check for "x".

if mycell.offset(0,-1).value = true then
'it's checked
else
'not checked
end if



Ray wrote:

Dave -

Would the same logic apply is I used the checkboxes and had them
linked to a cell (say A1:A30)? Instead of using another worksheet...?

thanks for your help today!
br//ray

--

Dave Peterson