Hi ,
One way you can do this by handling the CurrentCellValidateString event which does character wise validation.The CurrentCellValidateString is fired with each key. This examines each key stroke in a cell. Please refer to this KB article (
What are the different validation events and event members? When are they triggered and how are they used? ) for more details.
Best regards,
Haneef