assigning character length in a cell
 

I don't know if this is possible, but I'd like to basically tell a group of
cells how many characters it's allowed to have (one in this case), and after
I've entered the character, I'd like to automatically be moved to the next
cell without having to actually hit ENTER.

I need to enter about 600 1s and 2s, one number per cell, and as you can
imagine, hitting ENTER each time can become quite tedious.

Thanks in advance!

assigning character length in a cell
 

Hi,

If you select the cells you want. Then go to data validation. Select
length and change to equal to 1 that will restrict the text length to 1
character.


Next select the 600 cells click into the formula bar just below ariel
and this will allow you to tab throught all the cells

Only other way to avoid pressing enter would be a event macro

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=566361

assigning character length in a cell
 

Thanks for your answer. I tried it and it solved part of my problem, but I
should probably rephrase my questions b/c I just realized it wasn't very
clear. What I idealy would like is for my cursor or I guess the selection to
automatically move down to the next cell after I've finished typing in one so
that I don't have to hit Enter each time, which adds 600 extra keystrokes to
the other keystrokes I'm already making (I have to do this set 250 times). I
figured that if I could assign a character length to the cells, it would
eliminate the use of the Enter key, but that wasn't the case. I also tried
setting up a macro to no avail.

I basically want to type the numbers 1212122212221221221112 etc, each in its
own cell without hitting enter so the process goes much quicker.

I hope that makes more sense.

Audrey

"VBA Noob" wrote:


Hi,

If you select the cells you want. Then go to data validation. Select
length and change to equal to 1 that will restrict the text length to 1
character.


Next select the 600 cells click into the formula bar just below ariel
and this will allow you to tab throught all the cells

Only other way to avoid pressing enter would be a event macro

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=566361

assigning character length in a cell
 

tools option edit you can change the settings so that the cursor goes down
when you press enter or use the down arrow key intead of enter
--
paul

remove nospam for email addy!



"audrey" wrote:

Thanks for your answer. I tried it and it solved part of my problem, but I
should probably rephrase my questions b/c I just realized it wasn't very
clear. What I idealy would like is for my cursor or I guess the selection to
automatically move down to the next cell after I've finished typing in one so
that I don't have to hit Enter each time, which adds 600 extra keystrokes to
the other keystrokes I'm already making (I have to do this set 250 times). I
figured that if I could assign a character length to the cells, it would
eliminate the use of the Enter key, but that wasn't the case. I also tried
setting up a macro to no avail.

I basically want to type the numbers 1212122212221221221112 etc, each in its
own cell without hitting enter so the process goes much quicker.

I hope that makes more sense.

Audrey

"VBA Noob" wrote:


Hi,

If you select the cells you want. Then go to data validation. Select
length and change to equal to 1 that will restrict the text length to 1
character.


Next select the 600 cells click into the formula bar just below ariel
and this will allow you to tab throught all the cells

Only other way to avoid pressing enter would be a event macro

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=566361

assigning character length in a cell
 

Audrey

Until you hit Enter or Tab or an arrow key Excel has no way of knowing that you
are finished typing in that cell.

You must indicate in some way that you are ready to go to next cell.

Data Validation only shows a message after you have left the cell.

Event code still requires you to leave the cell before it triggers.


Gord Dibben MS Excel MVP

On Sun, 30 Jul 2006 01:27:01 -0700, audrey
wrote:

Thanks for your answer. I tried it and it solved part of my problem, but I
should probably rephrase my questions b/c I just realized it wasn't very
clear. What I idealy would like is for my cursor or I guess the selection to
automatically move down to the next cell after I've finished typing in one so
that I don't have to hit Enter each time, which adds 600 extra keystrokes to
the other keystrokes I'm already making (I have to do this set 250 times). I
figured that if I could assign a character length to the cells, it would
eliminate the use of the Enter key, but that wasn't the case. I also tried
setting up a macro to no avail.

I basically want to type the numbers 1212122212221221221112 etc, each in its
own cell without hitting enter so the process goes much quicker.

I hope that makes more sense.

Audrey

"VBA Noob" wrote:


Hi,

If you select the cells you want. Then go to data validation. Select
length and change to equal to 1 that will restrict the text length to 1
character.


Next select the 600 cells click into the formula bar just below ariel
and this will allow you to tab throught all the cells

Only other way to avoid pressing enter would be a event macro

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=566361