Emoncada
05-28-2010, 08:36 AM
I have 6 Checkboxes.
Chkbox1, Chkbox2, ...- Chkbox6.
Each has a Caption of it's own number.
So Chkbox1.Caption = "1", Chkbox2.Caption = "2"
What I would like is transfer the True values of the chkboxes to one cell seperated by a ",".
So If chkBox1 & chkBox6 is True Then Range("H6").value = "1,6"
Chkbox1, Chkbox2, ...- Chkbox6.
Each has a Caption of it's own number.
So Chkbox1.Caption = "1", Chkbox2.Caption = "2"
What I would like is transfer the True values of the chkboxes to one cell seperated by a ",".
So If chkBox1 & chkBox6 is True Then Range("H6").value = "1,6"