Form listbox error when date is not entered

[rob_h]

Hello all,
I have a user form setup to allow editing/updating records on a worksheet. The form has a list box that is used to display filtered records and then by clicking a record, its values are added to the form controls for editing. There are two date columns, one is for when the record is added to the worksheet, the other is left blank until the project is completed. Both are formatted as custom date (mm/dd/yyyy).

It's the second, blank date field, that is causing a type-mismatch error when the record is clicked on in the list box. I know what the problem is (a blank cell is not a valid date), just not sure how to tell VBA to allow this to be blank until an actual completed date is added.

Maybe adding an IF statement to skip over if blank?

Thank you

Please Login or Register  to view this content.

[AlphaFrog]

Replace this...

Please Login or Register  to view this content.

With this...

Please Login or Register  to view this content.

[rob_h]

Thank you, works great.