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

Userform Checkbox
 

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