code to deselect if empty record is clicked in listbox

I have a little tool to populate and filter data, the data gets manipulated through a list box.

When I click on a record in the list box, the record gets highlighted, which is fine. However, occasionally, I could also click on empty rows specially when I have less number of data records after I filter them. I need to disable/ deselect when I click on empty record.

I have this code in the list box click event, but it does not work for the purpose:

Private Sub lstBox1_Click()
Dim i As Integer
i = Me.lstBox1.ListIndex
If (Me.lstBox1.Column(1, i) = "") Then 'i.e. empty record
    Me.lstBox1.Selected(i) = False
Else
    Me.lstBox1.Selected(i) = True
End If
End Sub

Any idea why it is not working? . I am also attaching an excel file in the following link:
https://www.dropbox.com/s/aw36c56n2z...s_LT.xlsm?dl=0

I appreciate any help .. Thanks