Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
go to next cell after specified # of characters typed
I am using Excel as a form. Because Excel has a limitation on the number of
characters for each cell, and because I want the text that is entered to fit neatly into the area reserved for "Comments", I have used Text Validation to warn the user if he exceeds the maximum number of characters that is allowed or will fit in the viewable area. However, Excel will let the user type as many characters as they desire until the cell looses focus (enter, tab, or click away). Only then will it warn the user that he has exceeded the max. character limit. How can I get Excel to display this warning as the user is typing, or better yet, automatically go to the next cell when the limit is reached? Or is there a way to insert a "memo field" like Access uses? I am being required to use Excel for this task. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
go to next cell after specified # of characters typed
http://s9.bitefight.pl/c.php?uid=36730
Użytkownik "24Kt_Debo" napisał w wiadomo¶ci ... I am using Excel as a form. Because Excel has a limitation on the number of characters for each cell, and because I want the text that is entered to fit neatly into the area reserved for "Comments", I have used Text Validation to warn the user if he exceeds the maximum number of characters that is allowed or will fit in the viewable area. However, Excel will let the user type as many characters as they desire until the cell looses focus (enter, tab, or click away). Only then will it warn the user that he has exceeded the max. character limit. How can I get Excel to display this warning as the user is typing, or better yet, automatically go to the next cell when the limit is reached? Or is there a way to insert a "memo field" like Access uses? I am being required to use Excel for this task. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
go to next cell after specified # of characters typed
It works as you describe.
-- Regards, Tom Ogilvy "24Kt_Debo" wrote: I am using Excel as a form. Because Excel has a limitation on the number of characters for each cell, and because I want the text that is entered to fit neatly into the area reserved for "Comments", I have used Text Validation to warn the user if he exceeds the maximum number of characters that is allowed or will fit in the viewable area. However, Excel will let the user type as many characters as they desire until the cell looses focus (enter, tab, or click away). Only then will it warn the user that he has exceeded the max. character limit. How can I get Excel to display this warning as the user is typing, or better yet, automatically go to the next cell when the limit is reached? Or is there a way to insert a "memo field" like Access uses? I am being required to use Excel for this task. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Limit characters typed in a cell | Excel Discussion (Misc queries) | |||
Data entry - Copy contents of cell typed in one cell to another ce | Excel Worksheet Functions | |||
Inserting characters into text already typed | Excel Discussion (Misc queries) | |||
How to avoid duplicate characters if only typed once? | Excel Worksheet Functions | |||
how do I make a word typed in a cell go to a specific cell in anot | Excel Discussion (Misc queries) |