auto tab when cell is full
 

Does anyone know of a quick and easy way to automatically advance to the
next cell when the maximum number of characters is reached in the cell?
I want to eliminate the need to press the tab or enter keys to speed up
the input of data.


--
univarhb
------------------------------------------------------------------------
univarhb's Profile: http://www.excelforum.com/member.php...o&userid=33913
View this thread: http://www.excelforum.com/showthread...hreadid=536877

auto tab when cell is full
 

"univarhb" wrote in
message ...

Does anyone know of a quick and easy way to automatically advance to the
next cell when the maximum number of characters is reached in the cell?
I want to eliminate the need to press the tab or enter keys to speed up
the input of data.

No, but remember that the limit is 32767 characters per cell (in Excel
2003).
--
David Biddulph

auto tab when cell is full
 

Excel has no way of knowing when a certain number of characters has been entered
in a cell until you indicate in some manner that this is so.

i.e. hit enter, tab or arrow key to leave the cell

So...............no, there is no method to eliminate the need to press a key.


Gord Dibben MS Excel MVP

On Thu, 27 Apr 2006 11:32:22 -0500, univarhb
wrote:


Does anyone know of a quick and easy way to automatically advance to the
next cell when the maximum number of characters is reached in the cell?
I want to eliminate the need to press the tab or enter keys to speed up
the input of data.

auto tab when cell is full
 

You could build a userform that counts the characters and when the limit is
reached, it could go to the next cell (whatever that means).



univarhb wrote:

Does anyone know of a quick and easy way to automatically advance to the
next cell when the maximum number of characters is reached in the cell?
I want to eliminate the need to press the tab or enter keys to speed up
the input of data.

--
univarhb
------------------------------------------------------------------------
univarhb's Profile: http://www.excelforum.com/member.php...o&userid=33913
View this thread: http://www.excelforum.com/showthread...hreadid=536877

--

Dave Peterson