Loading

How to validate excel cell characters length use macro code?

Raja

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.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sundaram Subramanian9y ago
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 Varman9y ago
Please refer the link for more detailed explanation:http://www.excelcommand.com/excel-help/excel-how-to.php?i=451677