I have already formated a column to Date and wish users to enter the date using the forward slash delimiters, however, users are sometimes
entering the date using the dot(full stop) as a delimiter.
I would like to force the dot to a forward slash as it is entered. However, if this involves the use of API I am NOT familiar with this use of it.
As an alternative to the above the dot delimiter can be changed to a forward slash as the user exits the cell for the next cell if this makes the coding easier.
It should be noted that some users use a leading zero for single digits and some do not that is why I thought it would be better to concentrate on the date delimiters.
ie 01.01.2016 to 01/01/2016 or 1.1.2016 to 01/01/2016
Finally, as if I havent made my request hard enough, I would like to be able to hide this code from the user.
Any help on some VBA code to do the above would be greatly appreciated.
Regards
Doc666