Excel 2016
I have a tick box which refers to cell A1.
This returns TRUE in A1 when ticked and FALSE when unticked.
I want TRUE too actually read "Booked" and FALSE to read "Not Booked"
Help much appreciated...
Tried IF functions to no avail.
Thanks


Jim

I don't think you can change the value that check boxes return, but there are probably other ways to skin that cat. You could use a drop down or a list box. Or you could have an if statement in another cell that will return your words based on the checkbox value. Or you could write some code that would populate that cell based on the checkbox change event.

Yes, I had a play with a statement in another cell like:
=IF(B14=TRUE, "Booked", "Not Booked") and then in B14 changed the text to White.
Bit of a workaround but functional!!
Would have preferred some code but not within my skill base!!
Many thanks
Jim