I dont know why this is so hard!! Checkboxes???

[teachnmyself]

Ok. so i've been working with excel/vba for a year now but never had to deal with checkboxes before. someone please help.
All i need is this: i have a 3 checkboxes(on a userform) simply labeled 1,2,and 3. each of the captions have an action. i need the the checked actions to populate in a text box when command button1 is pushed... Easy right?? It must be so easy that nobody ever asked about it cause i am a member to 3 different excel forums and cant find the answer anywhere.. am I retarded or something?

 

[ACCtionMan]

You could add something like the following

Private Sub CommandButton1_Click()
If Me.CheckBox1.Value = True Then ' the value of a checkbox is either True (checked) or False (not checked)
Me.TextBox1.Value = "checkbox 1 clicked"
End If
End Sub

 

[teachnmyself]

awesome thanks, now what if user checks a box then changes their mind is it as easy as

Private Sub CheckBox1_Click()
if Me.CheckBox1.Value = True
else me.checkbox1.value = false


End Sub

like i said im new to checkboxes

 

[ACCtionMan]

That's ok, everyone has to start somewhere.

It depends if you still want to do something if the checkbox is not selected. If you don't then the code would simply run through without doing anything as the line
'If Me.CheckBox1.Value = True'
Is not true so the 'If' statement is skipped.

This code does something for both a True and False outcome.

Private Sub CommandButton1_Click()
If Me.CheckBox1.Value = True Then ' the value of a checkbox is either True (checked) or False (not checked)
Me.TextBox1.Value = "checkbox 1 clicked"
ElseIf Me.CheckBox1.Value = False Then
' do something here, eg
Me.TextBox1.Value = "checkbox 1 not selected'
End If
End Sub

 

[teachnmyself]

thanks alot.. this will def get me going in the right direction last question for ya.. why is it i cant uncheck the boxes? then i promise to be done for the night. Im getting the evil eye from the Mrs.

 

[ACCtionMan]

In the VBA editor, you might have the 'Value' property of the checkbox set to 'True'. If so change this to 'False'. This is the default setting when the form, the checkbox is on, loads.

If it's when the code is running and you are trying to use the form then the 'Enabled' property might be set to 'False'. If so change it to 'True'. 'False' basicaly locks the checkbox which would come in handy if you didn't want to let someone change it until some other action had been performed.