without having looked at the sheet
can only take assumption in what your trying to do
i think your transferring to spreadsheet maybe the issue
you are somehow taking the caption instead of value?
whereby
checkbox1 = first answer
A1 = destination cell
extrapolate this for all 4
Also assume you should only have one answer so suggest using Option button (with groupbox) instead of checkbox
alternatively use a combo box and
use select Case
Select Case [form name] (whatever the form control is)
Case " answer 1"
Range("a1") = 1
case "answer 2"
Range "A1" = 2
...etc
end select
Bookmarks