Quick method of replicating check boxes and relevant cell link

I am designing a pupil data sheet where I am using a fairly large number of check boxes to record a response of TRUE or FALSE in an adjacent cell. I need to replicate a column of tick boxes that have a cell link referenced to the cell in the column next to it; I have been doing it manually and gave up after 5.

I know I could achieve this using a Yes or No or 1 or 0 from a drop down list for each cell; but the tick boxes look and feel right. And for busy teachers it needs to be quick and effective.

Any help would be gratefully appreciated

Ken

Hi Leith

This is superb and I really appreciate the time and effort you have given. Worked like a charm!

I am an educational advisor in Plymouth in the UK. My own excel skills are to say the least fairly limited so to have a piece of code like this in a pupil progress sheet that may be used across the city to support a national programme is very helpful.

What a great forum this is!

Once again many thanks

Ken

The code worked great for me as well. Although I realized that I wanted to edit the check boxes that I had just created after I ran the macro. I attempted to delete them and then rerun the macro after making my adjustments in the VB editor, but they do not delete very easily since they are the same size as the cells. Is there a way to mass delete the checkboxes or do I need to delete them one by one?

Hello SDDriver,

Use this macro to delete all the CheckBoxes on the Worksheet...

Please Login or Register  to view this content.

Sincerely,
Leith Ross