| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can you limit the amount typed in a cell in Excel 2003?
I have a template I have used for years but the problem is everytime you fill
the cell up you have to stop, go down to the next cell and continue. Is there a way to make it auto enter to the next cell when the range you are typing in is full? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can you limit the amount typed in a cell in Excel 2003?
It is difficult because of fonts and font sizes. It is much easier to count
the characters as they are being typed and shift down once a limit has been reached. -- Gary''s Student - gsnu200745 "Rezzolve" wrote: I have a template I have used for years but the problem is everytime you fill the cell up you have to stop, go down to the next cell and continue. Is there a way to make it auto enter to the next cell when the range you are typing in is full? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can you limit the amount typed in a cell in Excel 2003?
I don't think that this will work.
Your macro won't work while the user is typing in a cell. Maybe creating a userform and counting the characters would work for the OP, though. Gary''s Student wrote: It is difficult because of fonts and font sizes. It is much easier to count the characters as they are being typed and shift down once a limit has been reached. -- Gary''s Student - gsnu200745 "Rezzolve" wrote: I have a template I have used for years but the problem is everytime you fill the cell up you have to stop, go down to the next cell and continue. Is there a way to make it auto enter to the next cell when the range you are typing in is full? -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can you limit the amount typed in a cell in Excel 2003?
Hi Dave:
I was thinking of using Steve Bullen's CheckKey technique to read keyboard strokes as they were being entered: http://www.oaltd.co.uk/Excel/Default.htm -- Gary''s Student - gsnu200745 "Dave Peterson" wrote: I don't think that this will work. Your macro won't work while the user is typing in a cell. Maybe creating a userform and counting the characters would work for the OP, though. Gary''s Student wrote: It is difficult because of fonts and font sizes. It is much easier to count the characters as they are being typed and shift down once a limit has been reached. -- Gary''s Student - gsnu200745 "Rezzolve" wrote: I have a template I have used for years but the problem is everytime you fill the cell up you have to stop, go down to the next cell and continue. Is there a way to make it auto enter to the next cell when the range you are typing in is full? -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can you limit the amount typed in a cell in Excel 2003?
I don't think that this will work when the user is typing in a cell.
Gary''s Student wrote: Hi Dave: I was thinking of using Steve Bullen's CheckKey technique to read keyboard strokes as they were being entered: http://www.oaltd.co.uk/Excel/Default.htm -- Gary''s Student - gsnu200745 "Dave Peterson" wrote: I don't think that this will work. Your macro won't work while the user is typing in a cell. Maybe creating a userform and counting the characters would work for the OP, though. Gary''s Student wrote: It is difficult because of fonts and font sizes. It is much easier to count the characters as they are being typed and shift down once a limit has been reached. -- Gary''s Student - gsnu200745 "Rezzolve" wrote: I have a template I have used for years but the problem is everytime you fill the cell up you have to stop, go down to the next cell and continue. Is there a way to make it auto enter to the next cell when the range you are typing in is full? -- Dave Peterson -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can you limit the amount typed in a cell in Excel 2003?
Here is an example from a post earlier this month. The routine is triggered
on a Selection Change: http://groups.google.com/group/micro...949af9e8704188 I have coded other examples that allow the user to enter text in a cell and have the status bar track the number of characters in the cell as they are being entered. -- Gary''s Student - gsnu200745 "Dave Peterson" wrote: I don't think that this will work when the user is typing in a cell. Gary''s Student wrote: Hi Dave: I was thinking of using Steve Bullen's CheckKey technique to read keyboard strokes as they were being entered: http://www.oaltd.co.uk/Excel/Default.htm -- Gary''s Student - gsnu200745 "Dave Peterson" wrote: I don't think that this will work. Your macro won't work while the user is typing in a cell. Maybe creating a userform and counting the characters would work for the OP, though. Gary''s Student wrote: It is difficult because of fonts and font sizes. It is much easier to count the characters as they are being typed and shift down once a limit has been reached. -- Gary''s Student - gsnu200745 "Rezzolve" wrote: I have a template I have used for years but the problem is everytime you fill the cell up you have to stop, go down to the next cell and continue. Is there a way to make it auto enter to the next cell when the range you are typing in is full? -- Dave Peterson -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can you limit the amount typed in a cell in Excel 2003?
I don't think I'd use this for what the OP wanted.
Gary''s Student wrote: Here is an example from a post earlier this month. The routine is triggered on a Selection Change: http://groups.google.com/group/micro...949af9e8704188 I have coded other examples that allow the user to enter text in a cell and have the status bar track the number of characters in the cell as they are being entered. -- Gary''s Student - gsnu200745 "Dave Peterson" wrote: I don't think that this will work when the user is typing in a cell. Gary''s Student wrote: Hi Dave: I was thinking of using Steve Bullen's CheckKey technique to read keyboard strokes as they were being entered: http://www.oaltd.co.uk/Excel/Default.htm -- Gary''s Student - gsnu200745 "Dave Peterson" wrote: I don't think that this will work. Your macro won't work while the user is typing in a cell. Maybe creating a userform and counting the characters would work for the OP, though. Gary''s Student wrote: It is difficult because of fonts and font sizes. It is much easier to count the characters as they are being typed and shift down once a limit has been reached. -- Gary''s Student - gsnu200745 "Rezzolve" wrote: I have a template I have used for years but the problem is everytime you fill the cell up you have to stop, go down to the next cell and continue. Is there a way to make it auto enter to the next cell when the range you are typing in is full? -- Dave Peterson -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Limit characters typed in a cell | Excel Discussion (Misc queries) | |||
| Can I limit the amount of text in a given cell? | Excel Discussion (Misc queries) | |||
| Can I limit the amount of characters in a cell? | Excel Worksheet Functions | |||
| Is there a limit on amount of text that can go into a cell? | Excel Discussion (Misc queries) | |||
| Can you Limit the number of caracters that can be typed in a cell? | Excel Programming | |||
Linear Mode
