Limit Each Cell To 2 Digits (Max) *Input*

[TPN]

Hello!

I would like to be able to limit data entry to two digits (numeric 01-48 only) in range B3-G3 such that the following can happen in this order:

(key in a 15 into B3 and immediately find the cursor is ready for input on C3)

Steps:
1) Place cursor on B3
2) Key in a 1
3) Key in a 5
4) Cursor is immediately on C3 waiting for input.
|
|
steps 1-4 repeat until 2 digits are entered in G3,

then:
5) Cursor moves to B4

Steps 1-4 repeat again until I stop entering data.

For numbers 1-9 I will enter 01, 02, 03, ....... 09 and its OK if the leading zero drops.

I can not find an event to trap, like a KeyDown event that I am familiar with in VB and in Access... I'd love it if I could trap the key press down so that I can interrogate the data being entered and take appropriate action.

Is this possible????

Thanks,
Anthony

 

[NARAYANK991]

Hi ,

See if this link is helpful :

http://stackoverflow.com/questions/...res-when-keys-are-pressed-when-editing-a-cell

Narayan

 

[TPN]

That looks very much like what I am wanting to do - I will look into that! Thank you!