check more text rows in a single cell

[shamanx]

Hello,

I would check a cell with 2 text rows:

- each row length must be max 25 digits long
- I need a warning or highlight or cell fill in case one row exceed the max length

I have set the data validation to check max length, non considering the row
Could someone help me?

Thanks a lot

Eduardo

 

[Fennek]

Hi,

untested:

function Test_Len(Ar as range)
Test_Len = "ok"
Tx = split(Ar, chr(10))
for each T in Tx
     if len(T) > 25 then Test_Len = "error"
next T
end function

regards