Code for if a cell value has more that 5 characters

[jshaw82]

I'm currently using a code within a Private sub that basically checks if a cell has a certain criteria then to do something

Please Login or Register  to view this content.

Currently I have what is above about 20 times with varying different words between the "" what i'm lookign to do is get rid of them all an just have it so it check if the cell has 5 characters or less. What could I use for this? If Cell.Value < len(5) maybe?

Thanks in advance

John

[hafizimran]

Please Login or Register  to view this content.

[jshaw82]

That works. I've had to do it

Please Login or Register  to view this content.