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:

Please Login or Register  to view this content.

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

when I deleted the Row in the Range to test the code.
the List box doesn't iterated the itself as desired. I guess, there is a problem with the code iterating the Listbox.

Check the attached file:-

Hi Vikas_Gautam

I do not see any thing has changed. To illustrate, please do the following steps:

- Let the userform starts.
- CLick on "project" radio button
- CLick on an empty area in the list box right below the last record... a blank record gets highlighted !!!

I need to prevent this... It still allowing a blank record to get clicked and highlighted.. Thanks

Problem is solved.

I choose plan B. that is , to redefine the Listbox RowSource using Filtered date each time filter is used. For this purpose I have used an extra Sub "RefreshListBox"

Check the attached file:-