ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   check box, so when you click on it it inserts a check mark into t. (https://www.excelbanter.com/excel-discussion-misc-queries/21825-check-box-so-when-you-click-inserts-check-mark-into-t.html)

Steve

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.

Dave Peterson

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

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


All times are GMT +1. The time now is 07:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com