View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul S Panoff Paul S Panoff is offline
external usenet poster
 
Posts: 6
Default Single Digit Entry

I have three separate cells defined as hundreds, tens and ones. I have
data validation set to only allow values between 0 and 9. Is there any
way to go to the next cell after a digit has been entered, without
pressing ENTER, TAB or Right Arrow? (i.e. Press "7" on numeric keypad
on tens cell, automatically go to ones field.)