Unfilled textboxes in userform creating problems.

Hi All.

Sorry.....only new to this forum and posted this on my welcome page.

Anyway.....I have setup a userform with many textboxes and all i am seeking to do is transfer the userform info onto my spreadsheet. The code i have is;

Please Login or Register  to view this content.

The problem is that i have six date fields (representing dates of birth and other important dates), and not all of these are required to be filled out by the user (ie - they are not mandatory). Problem is that if the user does not fill them out i get the runtime error 13 message "type mismatch", and the debugger is struggling with the fact that all date fields are not filled out. Does anyone know how to fix this? Cheers.

for each textbox you should write like this

Please Login or Register  to view this content.

Hi barmfield

Please add code tags around your code.

Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here