View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sparky AKA_Sparkticus Sparky AKA_Sparkticus is offline
external usenet poster
 
Posts: 12
Default run a macro wehn leaveing a cell ??

Can this be implemented or is there a vba way
i have to in put mileage and calculate total mileage dont want to input a
large list just use one entry point.

i have a sum which is

mileage + previous total = total

i have used a macro to copy new total to previous and move curser to mileage
ready for a new input but is this the only way or can vab do this after
hitting enter on mileage??

Sparkyman