Hi,

I'm looking for a code to transform a number value in a userform to a date value after enter is pressed. For example, in the UF, the user would enter 010100, which would change to the date format 01-Jan-2000 after enter (or tab) is pressed or another cell selected. Any ideas? Thanks in advance,

Peter