Triggering code when leaving a cell.

Hello Everyone

I'm in the process of writing an Excel program that helps to pick out horses that stand a good chance of winning a race. In one column I need to type in the amount the distance a horse lost its last race by( "0L" if it won) IE: "5L" if it lost by 5 lengths, "6Y" if it lost by 6 yards etc. Most of the time it will lose by n Lengths. It would save a considerable amount of time if I only needed to type the number and when moving to another cell the program automatically adds the "L" after the number and if the horse only lost by n yards then it wouldn't add the "L". Is it possible to trigger code when leaving a cell and if it is, how do I do it?

Many thanks in advance.
Jim

Hi,

How will excel know that the data you entered is "L" or "Y"?

Rundie

Thanks very much for your help JP. It works a treat.

JosephP

Hi JP,

Your Code baffles me a bit. It works fine until you delete a Range in Column A, and then all the Cells within that Range gets populated with a "L".

I have tried to see how to "fix" this for you guys, but I seem stumped.

@ JosephP

Cool ! That is how I got to know you and your effective Coding.

I would never have thought of using the Len bit in there. Learnt something new today.

Thanks!

Thanks again JP. was having the same problem but the above code fixed it.