Hi, I need to create a form (checkbox type) with 567 checkboxes linked to 567 cells. I want to score a test that has that many questions. I tried using the no VB approach, but the hand cursor becomes a pain and I´ve been told the VB approach would be easier.

I have already designed the checkbox in Forms/UserForm1, it has 18 columns, from numbers 1 to 25 (vertical), 26 to 50, and so on, but I do not know how to link them to a cell. (Spent a long time doing that, (As you can tell, I am a real newby at this...) I am sure there is an easier way...

The idea is to have the value 1 if it is True and 0 if it is False. (if possible, to double click and have the value -1, which would mean that the person did not answer that question).

I´d really appreciate your help.
Carlosz