Add a Click event for a control

  1. Open the Script Editor.

    How?

  2. For the control to which you want to add a Click event, add the following, where CommandButton1 is the name of the control.

    Sub CommandButton1_Click

    End Sub

  3. Enter the code that you want in the event.