Prevent user from entering wrong values with custom error Message.

[Manoj]

Hi Haneef,

I want to prevent user from entering wrong values and show him with custom error Message like "Please enter number only" or "Values can only start with A".

Thanks in advance.

-Manoj.

[haneefm]

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