validate dates with checkboxes

[princess12]

Hi all, sorry for the trouble but i am trying to validate that



if textbox date is greater than listbox selected date then tick the checkbox
else if textbox date is smaller than listbox selected date then dont tick the checkbox.

this code sort of works but only focus on the first selection, after that if another selection occurs in the listbox, the validation doesnt work. please guide me to the right direction.

If listbox1.Column(8) > Me.txtDate Then
Me.checkbox= -1

Else
If listbox1.Column(8) < Me.txtDate Then
Me.checkbox= 0
End If
End If

a loop might be needed am not sure, i tried it but it goes wrong.

thank you

[June7]

Already marked solved - is it?

[princess12]

yes i completed it ages ago, sorry