Userform Checkbox

Hello,
I have a userform with twelve check boxes, cleverly titled CheckBox1,
CheckBox2, etc.

I would like to record the value of those check boxes on a worksheet (either
true or false). Is there a way of doing that without having to list each
checkbox.

I tried something like the following:

For i = 1 to 12
sheets(1).cells(i,1)=userform.checkbox & i
next i

But without success.

Thanks.

Bill

Try this:
Sheets(1).Cells(i,1) = UserForm1.Controls("CheckBox" & i).Value

HTH

Die_Another_Day
Bill wrote:
> Hello,
> I have a userform with twelve check boxes, cleverly titled CheckBox1,
> CheckBox2, etc.
>
> I would like to record the value of those check boxes on a worksheet (either
> true or false). Is there a way of doing that without having to list each
> checkbox.
>
> I tried something like the following:
>
> For i = 1 to 12
> sheets(1).cells(i,1)=userform.checkbox & i
> next i
>
> But without success.
>
> Thanks.
>
> Bill