nedwards902001
New member
- Joined
- Jul 17, 2017
- Messages
- 6
- Reaction score
- 0
- Points
- 0
I have entered the following VBA code to simulate a checkbox since I cannot resize the actual checkbox using the checkbox control.
Private Sub Label1_Click()
If Label1.Caption = Chr(254) Then
Label1.Caption = Chr(168)
Else
Label1.Caption = Chr(254)
End If
End Sub
The problem is I need to know how to replicate the code to several cells without manually adding a VBA code in each cell.
Any help would be appreciated. Thank you.
Private Sub Label1_Click()
If Label1.Caption = Chr(254) Then
Label1.Caption = Chr(168)
Else
Label1.Caption = Chr(254)
End If
End Sub
The problem is I need to know how to replicate the code to several cells without manually adding a VBA code in each cell.
Any help would be appreciated. Thank you.