excel vba - listbox displays 12/30/99 when value is null

I haven't been able to find anything online similar to this and I'm not sure how to code this. I have a ListBox that list date inputs (beginning and ending dates). Sometimes the inputs are left blank until the user inputs a date. The code works fine for date input and the ListBox displays everything correctly when dates are input, but if dates are blank, the ListBox displays 12/30/99 (12/30/1899). I added an If Then Else statement to the listbox fill routine to look at the row cell value and return a nullvalue if cell is empty or display a date when filled. What I have now, which obviously doesn't work, now leaves the ListBox date value null whether there is a sheet value or not. Anybody see where I'm going astray?

Please Login or Register  to view this content.

Thanks shg for that. I don't think I'm writing it correctly though. It solves the display issue..partially. When there is no date, it still displays the Microsoft default date 12/30/99.

this seemed to have fixed it

Please Login or Register  to view this content.