View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Single Digit Entry

Hi Paul
not really possible. Harlan Grove posted some time ago a procedure
using API calls, etc. Problem is: Macros are not executed while you're
in edit mode. So you have to hit ENTER or TAB

--
Regards
Frank Kabel
Frankfurt, Germany


Paul S Panoff wrote:
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.)