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.
Bookmarks