check box, so when you click on it it inserts a check mark into t.

I would like to create electronic check lists so that when users click on the
small box with the cursor the box is shown as checked off in the list.

You could add a bunch of checkboxes from the Forms toolbar.

If you want to check the status of the checkbox later, you can use a Linkedcell
to keep track of each checkbox.

Just rightclick on each of the checkboxes
then Format Control|Control Tab
use a different cell for each checkbox (Cell link box)

Steve wrote:
>
> I would like to create electronic check lists so that when users click on the
> small box with the cursor the box is shown as checked off in the list.

--

Dave Peterson

ps.

Then you can do things like:

=if(a1=true,"It's checked","nope")



Steve wrote:
>
> I would like to create electronic check lists so that when users click on the
> small box with the cursor the box is shown as checked off in the list.

--

Dave Peterson

Use the forms toolbar to create a check box - eg in cell A1
right click check box and under format control link to a cell eg B1 - which will now toggle True / False.
In your list that you need to check off use conditional formatting with something like this set


Condition 1

Foemula is =$B$1=TRUE

Then change the font setting to strike through.

Now when you check the box the text is crossed out

Regards

Stuart