How to show in ListBox1 just rows with empty column I

[Jurasraja]

Hello VBA engineers

I have a little issue with my macro in excel VBA 2016 and hope that there is somebody to help me. Let me introduce the problem.

I have a database on Sheet1 called "TPM". That database is variable, so it means that I add new inputs every day. I have window called "Realizace TPM" there and ListBox1 in that window. So I really need to show just rows with full Column A and empty Column I. Other inputs not to show there! If row would be empty or with full Column I - doesn´t show it in this ListBox1.

And the second part this problem that If I choose one input from this ListBox and write a date under this ListBox to TextBox called "lbxDatum" I want to write the date to choose row to Column I "Datum realizace".

I try everything, I google it for 3 days and still I dont know How to make it

Thank you for the answers
+
I have no idea how to update excel file, maybe I am new here so I cant update links and files

[maniacb]

You are more likely to get a response if you refer to orange block above, please add an example workbook