Your code need to be triggered by some event, say textchanged or click event (for combo box), see
example[
^].
If you just want to unchecked the checkbox1 when the textbox value is 5 then this will do:
If ComboBoxyear.Text = 5 Then
CheckBox1.Checked = False
Else
CheckBox1.Checked = True
End If