Cells(1,1) = CheckBox1.Value & "," & CheckBox2.Value & "," & CheckBox3.Value

If this post helps click Yes
---------------
Jacob Skaria


"A#'s" wrote:

Hi,

I've created a userform with a number of check boxes. I'm trying to get the
text value of one or more checkboxes when selected returned to a single cell
on my worksheet using a comma as the seperator between each value.

Is it possible to have something on VBA to do that for me?

Thanks.