Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Checking the length of cell contents
I'm trying to set up a spreadsheet where the contents of cell A1 has a max
length of 128 characters. I want to give the number of characters left in cell B1 which updates each time a character is entered in A1 without the user having to press Enter. Is this posible, and if so, does anyone know how? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Checking the length of cell contents
In B1 put............
=128-LEN(A1) Vaya con Dios, Chuck, CABGx3 "RichardG" wrote: I'm trying to set up a spreadsheet where the contents of cell A1 has a max length of 128 characters. I want to give the number of characters left in cell B1 which updates each time a character is entered in A1 without the user having to press Enter. Is this posible, and if so, does anyone know how? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Checking the length of cell contents
That's what I'm using at the minute, but that only changes when you press
Enter. Is there any way of changing B1 without pressing Enter? "CLR" wrote: In B1 put............ =128-LEN(A1) Vaya con Dios, Chuck, CABGx3 "RichardG" wrote: I'm trying to set up a spreadsheet where the contents of cell A1 has a max length of 128 characters. I want to give the number of characters left in cell B1 which updates each time a character is entered in A1 without the user having to press Enter. Is this posible, and if so, does anyone know how? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Checking the length of cell contents
Nope.
You could make a small userform that counts the characters--each time they change the textbox in the userform. === Just curious--are you using data|validation to stop the entry at 128 characters? RichardG wrote: That's what I'm using at the minute, but that only changes when you press Enter. Is there any way of changing B1 without pressing Enter? "CLR" wrote: In B1 put............ =128-LEN(A1) Vaya con Dios, Chuck, CABGx3 "RichardG" wrote: I'm trying to set up a spreadsheet where the contents of cell A1 has a max length of 128 characters. I want to give the number of characters left in cell B1 which updates each time a character is entered in A1 without the user having to press Enter. Is this posible, and if so, does anyone know how? -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Checking the length of cell contents
but that only changes when you press
Enter. Not so...........it will change if you increase the number of characters in A1 with VBA and it will change with a CopyAndPaste also............so, exactly how are you changing the number of characters? Vaya con Dios, Chuck, CABGx3 "RichardG" wrote: That's what I'm using at the minute, but that only changes when you press Enter. Is there any way of changing B1 without pressing Enter? "CLR" wrote: In B1 put............ =128-LEN(A1) Vaya con Dios, Chuck, CABGx3 "RichardG" wrote: I'm trying to set up a spreadsheet where the contents of cell A1 has a max length of 128 characters. I want to give the number of characters left in cell B1 which updates each time a character is entered in A1 without the user having to press Enter. Is this posible, and if so, does anyone know how? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Checking the length of cell contents
I read the OP's question as though the user was typing in the formula bar. And
B1 should contain the current count of characters while the user is typing. But I've read lots of messages incorrectly <bg. CLR wrote: but that only changes when you press Enter. Not so...........it will change if you increase the number of characters in A1 with VBA and it will change with a CopyAndPaste also............so, exactly how are you changing the number of characters? Vaya con Dios, Chuck, CABGx3 "RichardG" wrote: That's what I'm using at the minute, but that only changes when you press Enter. Is there any way of changing B1 without pressing Enter? "CLR" wrote: In B1 put............ =128-LEN(A1) Vaya con Dios, Chuck, CABGx3 "RichardG" wrote: I'm trying to set up a spreadsheet where the contents of cell A1 has a max length of 128 characters. I want to give the number of characters left in cell B1 which updates each time a character is entered in A1 without the user having to press Enter. Is this posible, and if so, does anyone know how? -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Checking the length of cell contents
That's interesting.........and of course I agree with your response be that
the case.......but I read it as literally the characters being IN A1.........hence my question. cell B1 which updates each time a character is "ENTERED IN A1" without the user having to press Enter. Vaya con Dios, Chuck, CABGx3 "Dave Peterson" wrote: I read the OP's question as though the user was typing in the formula bar. And B1 should contain the current count of characters while the user is typing. But I've read lots of messages incorrectly <bg. CLR wrote: but that only changes when you press Enter. Not so...........it will change if you increase the number of characters in A1 with VBA and it will change with a CopyAndPaste also............so, exactly how are you changing the number of characters? Vaya con Dios, Chuck, CABGx3 "RichardG" wrote: That's what I'm using at the minute, but that only changes when you press Enter. Is there any way of changing B1 without pressing Enter? "CLR" wrote: In B1 put............ =128-LEN(A1) Vaya con Dios, Chuck, CABGx3 "RichardG" wrote: I'm trying to set up a spreadsheet where the contents of cell A1 has a max length of 128 characters. I want to give the number of characters left in cell B1 which updates each time a character is entered in A1 without the user having to press Enter. Is this posible, and if so, does anyone know how? -- Dave Peterson |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Checking the length of cell contents
Dave - Yopu're right - the text would be typed into cell A1 and appear in the
formula bar as normal. There is also the option of direct cell editing as usual. "CLR" wrote: That's interesting.........and of course I agree with your response be that the case.......but I read it as literally the characters being IN A1.........hence my question. cell B1 which updates each time a character is "ENTERED IN A1" without the user having to press Enter. Vaya con Dios, Chuck, CABGx3 "Dave Peterson" wrote: I read the OP's question as though the user was typing in the formula bar. And B1 should contain the current count of characters while the user is typing. But I've read lots of messages incorrectly <bg. CLR wrote: but that only changes when you press Enter. Not so...........it will change if you increase the number of characters in A1 with VBA and it will change with a CopyAndPaste also............so, exactly how are you changing the number of characters? Vaya con Dios, Chuck, CABGx3 "RichardG" wrote: That's what I'm using at the minute, but that only changes when you press Enter. Is there any way of changing B1 without pressing Enter? "CLR" wrote: In B1 put............ =128-LEN(A1) Vaya con Dios, Chuck, CABGx3 "RichardG" wrote: I'm trying to set up a spreadsheet where the contents of cell A1 has a max length of 128 characters. I want to give the number of characters left in cell B1 which updates each time a character is entered in A1 without the user having to press Enter. Is this posible, and if so, does anyone know how? -- Dave Peterson |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Checking the length of cell contents
And now you know that there's nothing built into excel that works that way.
So unless you do something special (like a userform), then it can't be done. RichardG wrote: Dave - Yopu're right - the text would be typed into cell A1 and appear in the formula bar as normal. There is also the option of direct cell editing as usual. "CLR" wrote: That's interesting.........and of course I agree with your response be that the case.......but I read it as literally the characters being IN A1.........hence my question. cell B1 which updates each time a character is "ENTERED IN A1" without the user having to press Enter. Vaya con Dios, Chuck, CABGx3 "Dave Peterson" wrote: I read the OP's question as though the user was typing in the formula bar. And B1 should contain the current count of characters while the user is typing. But I've read lots of messages incorrectly <bg. CLR wrote: but that only changes when you press Enter. Not so...........it will change if you increase the number of characters in A1 with VBA and it will change with a CopyAndPaste also............so, exactly how are you changing the number of characters? Vaya con Dios, Chuck, CABGx3 "RichardG" wrote: That's what I'm using at the minute, but that only changes when you press Enter. Is there any way of changing B1 without pressing Enter? "CLR" wrote: In B1 put............ =128-LEN(A1) Vaya con Dios, Chuck, CABGx3 "RichardG" wrote: I'm trying to set up a spreadsheet where the contents of cell A1 has a max length of 128 characters. I want to give the number of characters left in cell B1 which updates each time a character is entered in A1 without the user having to press Enter. Is this posible, and if so, does anyone know how? -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell checking | New Users to Excel | |||
Conversion of Cell Contents into a Functional Worksheet name ? | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
cell contents | Excel Discussion (Misc queries) | |||
Display actual contents of cell | Excel Discussion (Misc queries) |