Private Sub UserForm_Initialize()
CheckBox1.Caption = ""
CheckBox2.Caption = ""
CheckBox3.Caption = ""
End Sub
Private Sub CheckBox1_Click()
CheckBox1.Caption = IIf(CheckBox1, [A2], " ")
End Sub
Private Sub CheckBox2_Click()
CheckBox2.Caption = IIf(CheckBox2, [A3], " ")
End Sub
Private Sub CheckBox3_Click()
CheckBox3.Caption = IIf(CheckBox3, [A4], " ")
End Sub