You can paste this in a standard module and assign this macro to the
checkbox. Label the sheet and cell to suit your application. You can also
get rid of the linked cell if you don't need it anymore.

Sub GoodBad()

With Sheets("Sheet1")
If .CheckBoxes("Check Box 4").Value = xlOn Then
.Range("A1").Value = "GOOD"
Else
.Range("A1").Value = "BAD"
End If
End With

End Sub

Hope this helps! If so, please click "YES" below.

--
Cheers,
Ryan


"Doug" wrote:

I have a check box at the top of my sheet. I have a linked cell right next to
it that says either True or False. How can I get that to show different text?
Do I need to assign a macro and if so how would it be written. I want it to
either say "Good" when checked instead of true and "Bad" when unchecked
instead of False.

--
Thank you!