Creating a user-defined event

[Glory]

Do I use a class module?

User clicks a command button; command button toggles event on, so that clicking checkboxes clears their captions. Clicking the command button again toggles the event off.

Is this possible?

 

[tusharm]

Not sure if I understand you correctly, but for custom events see
Monitoring events
http://www.tushar-mehta.com/excel/vba/vba-XL events.htm

particularly the section
A simple event source and event sink

 

[mikerickson]

It sounds like you don't need an event, but a flag. If he Command Button toggles a variable Flag between true and false, then code like this in the checkboxes will clear the caption at the appropriate time.
For forms controls, that would look like

Dim Flag As Boolean

Sub Button4_Click()
    Flag = Not Flag
End Sub

Sub CheckBox3_Click()
    If Flag Then
        ActiveSheet.Shapes(Application.Caller).TextFrame.Characters.Text = ""
    Else
        Rem other checkbox click action
    End If
End Sub

 

[Glory]

Thanks very much for your input, mike. That's twice in two days you've pulled my *** out of the fire. I couldn't figure out either of these issues for the life of me, and the first (this one) was clear as day.

Edit: Would you mind explaining this line a little? "Rem other checkbox click action" Edit: Nevermind, I looked up the Rem statement and I understand.

 

[Glory]

Tusharm: If I ever think I need to deal with events again, this is where I'll come first. I appreciate the link.