How to validate excel cell characters length use macro code?

Question

I want to set only 15 characters allowed in excel cell.i use data(DATA Tab) validation in excel to give range of the excel cell.it is working when i type the letters.if i copy more then 15 characters and paste in the cell the validation is not working how to set the validation in excel cell.how to write the macro for excel.

Sundar · Answer

Private Sub Worksheet_SelectionChange(ByVal Target As Range) For Each cell In UsedRange If Len(cell.Value) > 15 Then MsgBox  Can't enter more than 15 characters cell.Value =  End If Next End Sub Try the above code. This may help you.

Gokhul Varman · Answer

Please refer the link for more detailed explanation:http://www.excelcommand.com/excel-help/excel-how-to.php?i=451677