Solved: Checkbox

[chungtinhlak]

I have a form with textbox that has default value when start, I also have a checkbox that will change these values when I click on it.

how do I make it so that when i check it, it changes, and when i uncheck it, it goes back to the default values when the userform_Initialize()???

thanks



Private Sub CheckBox1_Click()
txtbox1.Value = "I"
txtbox2.Value = "J"
End Sub
Private Sub UserForm_Initialize()
txtbox1.Value = "G"
txtbox2.Value = "H"
End Sub

[Bob Phillips]

Private Sub CheckBox1_Click()
With Me

If .CheckBox1.Value Then

.txtbox1.Value = "I"
.txtbox2.Value = "J"
Else

.txtbox1.Value = "G"
.txtbox2.Value = "H"
End If
End With
End Sub
Private Sub UserForm_Initialize()
txtbox1.Value = "G"
txtbox2.Value = "H"
End Sub

[chungtinhlak]

so whenever I do a checkbox*.value, i'm indicating that it's true?

[Bob Phillips]

No, not exactly. The Checkbox value is a boolean, True or False is its value. As an If test is justing checking for True or False in essence, you don't have to be explicit.



If Checbox1.Value Then


is the same as saying




If Checbox1.Value = True Then


The former is just more logical to my eyes.

[chungtinhlak]

so can di do a checkbox1.value = true for checked and checkbox1.value= false for unchecked?

[Bob Phillips]

Yes, but it is better to do



If CheckBox1.Value Then

'and

If Not CheckBox1.Value Then


IMO, as it is more aligned to boolean logic.

[chungtinhlak]

thanks you