Errror message

[dwarek]

Hello everyone i need a small piece of code. for example in column c i have alpha numeric characters like "PLN5555" so i need a code that prompts me error message when i type alpha numeric characters less than or greater than 7characters.
any one can help me out in this. thanks in advace

 

[oldbrewer]

if len(cells(1,1))<>7 then cells(1,2)="error"

 

[63falcondude]

You can use Data Validation to produce an error message when a value is entered that is not 7 characters.

Highlight column C > Data Validation > Allow: Text length > Data: equal to > Length: 7

Just note that this will allow any string of 7 characters including special characters such as -, ?, & etc.