check box that triggers macro

[EstherH]

Hi again,

How does one get a check box created by the control toolbox to trigger a
one condition when checked and another when not checked?

For far I have found that Sub CheckBox1_Click() can be used to trigger an
event. But this triggers the same event whether checking or unchecking.

What is the if statement that captures the checked and unchecked values for
this box?

 

[Chuck Henrich]

Use the following

Sub CheckBox1_Click()
If Me.CheckBox1.Value = True Then
'checkbox ticked - do something
Else
'checkbox not ticked - do something different
End If
End Sub

HTH

 

[EstherH]

That was quick. Thanks. That's exactly what I needed.