Run code on data validation

[npacker]

Is there a way to have a piece of code run when a data validation meets certain criteria? I've got a data validation that puts up an info box when a user puts more thatn 1024 characters in a cell. Can I have it run some code at that time? Or is there a better way to have some code run as soon as more than 1024 characters are typed in any cell?
Thanks,
nate

 

[macleanb]

I would probably use the worksheet changed event to trap inputs and then examine target.value to see what they had input - if you need help on creating event handlers let me know

 

[Greg Truby]

You can use the worksheet's _Change() event handler for this type of thing. But note that it only fires after the user has hit the Enter key. There is no way to run a macro while a user is in Edit mode (while they're typing).