Current Code not working

[zplugger]

Have to code but getting problem if more then one character is in C13. Works perfect if only one character is typed in cell,how can I change
it so if more then one invalid character is in cell? Thanks for any suggestions. Z
For example this get error 45 elm. 4/23/2015

Please Login or Register  to view this content.

This is the code on userform yes button

Please Login or Register  to view this content.

[buran]

There is no need to check with InStr. Just loop trough invalid chars and use the replace. If the char is not found nothing will happen.

Please Login or Register  to view this content.

[zplugger]

Thanks buran
Getting error still? This only happens if more then one character is inputed.
Form already displayed;can't show modally

[buran]

Oh, I misunderstood your problem. Sorry

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[zplugger]

Thanks buran, seems to be working now.