Date Formatting Issues

[Pacman52]

Hi all I have a workbook with various Userforms on it for a user to input the relevant data into. I am currently entering some test data and have stumbled across an issue with some date formatting not being written to the worksheet correctly.

The odd thing is this seems to only happen on some rows and not all of them which to me makes me think the problem is with the worksheet formatting not the code behind the Userform. The Worksheet isn't storing the data as a table.

I've tried formatting the relevant columns on the worksheet by clicking on both the column reference letter and the individual cell and even changing the cell format to something other than a date and then back again but nothing seem to work.

Has anyone got any idea what's going with this and how to sort it out. I'm happy to provide more info and show the relevant code from the Userform if need be but as said the fact some rows work and some don't I'm pretty sure its not a code related problem.

Thanks for any responses Paul

 

[dmt32]

Hi all thanks as always for the support and advice.

Thanks again Paul

Hi
just be aware CDate will error if no valid date is entered.

Glad we were able to help & appreciate your feedback

Dave

 

[Pacman52]

Thanks Dave

I've coded the relevant areas to 'force' the user to input any dates in a date format so should not get any errors on the CDate.

Paul