| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Cell reference in the auto filter custom list | Excel Discussion (Misc queries) | |||
| Conditional formatting a full row triggered by a single cell | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| SQL - Auto Refresh Upon Cell Value Change | Excel Worksheet Functions | |||
Linear Mode
