G Guest May 28, 2004 #1 I need to type 1 letter or number in a cell - and excel knows to "auto tab" to the next cell to the right.
I need to type 1 letter or number in a cell - and excel knows to "auto tab" to the next cell to the right.
F Frank Kabel May 28, 2004 #2 Hi not possible (or only with some not very robust constructs). Reason: macros are not executed while in Edit mode -- Regards Frank Kabel Frankfurt, Germany Whelanj said: I need to type 1 letter or number in a cell - and excel knows to Click to expand... "auto tab" to the next cell to the right.
Hi not possible (or only with some not very robust constructs). Reason: macros are not executed while in Edit mode -- Regards Frank Kabel Frankfurt, Germany Whelanj said: I need to type 1 letter or number in a cell - and excel knows to Click to expand... "auto tab" to the next cell to the right.
L Lady Layla May 28, 2004 #3 You could hit enter after entering the info in the cell and set Excel to move to right upon enter Tools Options Edit Check by move after enter and select Right "Whelanj" <JW> wrote in message : I need to type 1 letter or number in a cell - and excel knows to "auto tab" to the next cell to the right.
You could hit enter after entering the info in the cell and set Excel to move to right upon enter Tools Options Edit Check by move after enter and select Right "Whelanj" <JW> wrote in message : I need to type 1 letter or number in a cell - and excel knows to "auto tab" to the next cell to the right.
D Dave Peterson May 29, 2004 #4 Or you could use a small userform that only accepts one character. Here's an example to get just a single digit: http://groups.google.com/[email protected]
Or you could use a small userform that only accepts one character. Here's an example to get just a single digit: http://groups.google.com/[email protected]
