Check boxes are linked to another cell (you specified this when you set
up the check box). So if "Checkbox1" is linked to cell A10, cell A10
will show TRUE when Checkbox1 is ticked and FALSE when it is unchecked.
In any other cell you could then write an IF statement along the lines
of
=IF(A10=TRUE,"Your text here","")