Hi Terry,
What you need to do is link the checkbox to a cell, I picked the cell it is in C17. when it is linked it will give that cell the value TRUE or FALSE depending on if it is checked or unchecked.
you can set the linked cell by right clicking the checkbox and pick form control item at the bottom of the menu.
then change the formula in E1 to
and that will make it possible to show a value or not.
in the sheet I left the text color of C17 white so you can see what is happening but ofcourse in the final sheet you can give the text the same color as the background
Bookmarks