How to insert VBA CheckBox control in Excel Sheet (ActiveX control)?
How to use VBA Check Box ? You can embed this control in Excel in the same way as the option buttons. The important thing compare to the VBA option button is that you can select more than one option using Check box. The Check Box selected by the user returns True Value. Unselected Check Box field returns False value. You can choose Check box control from insert icon in Developer’s Tab.
You can change the text of check box field in simple way. After inserting, go right-click to Properties window and change the value in the Caption field and enter your text.
How to insert VBA CheckBox control in VBA UserForm (ActiveX control)?
If you want to use Check Box control in VBA UserForm, all you have to do is open VB Editor and insert Check Box from ToolBox window while UserForm is open.
Programming VBA Check Box (ActiveX control)
How do I put the value of the CheckBox to the VBA code? As I said, the check box value when selected is True. Let’s try to program them using the If Then Else conditional statement. Try to insert three check boxes in Excel Sheet. Insert Also Command Button. When everything is done, click your command button in Design Mode and enter the code:
Private Sub CommandButton1_Click()
MsgBox "Your skills:"
If CheckBox1 = True Then
If CheckBox2 = True Then
If CheckBox3 = True Then
End IfEnd Sub
VBA Check Box Properties
In Command Button properties window you can edit many parameters of checkbox, that you inserted into Excel Sheet or User Form. You can change for example:
- (name) – name using in programming Check Box
- Caption – Text written on the check box
- Font – Font and text style