Hi I am VERY new to Excel VB and require some assistance

I have used a large number of form check boxes which i have linked to a various cells (say A1:A10) on a worksheet (call it worksheet 1).

When any of the check boxes in the range is checked (ie TRUE) I want to write "True" in another cell in another worksheet (say worksheet 2)

If more than one checkbox in the range is checked (True). I want it to write "True" in another cell in the worksheet in the next available cell. eg if checkbox 1 is checked then is will write in cell A1, if checkbox 2 is checked it will write in cell A2 etc. So it must just write the text in the next available cell. Not all the checkboxes may necessarily be checked (if only checkbox 3 is checked then it must still write in cell A1)

I have tried to write an if statement for this but I keep getting errors.

Can anyone help???