| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I limit the character length of a cell when typing
Hi,
I need to limit the number of characters (text and number, spaces excluded) that can be typed in, in a cell. Validation won't do for me because error occurs after pressing enter. I want to let users know that they cannot write more than certain characters in a cell as they write (forcefully stopping character input after certain number of characters). Please Help! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I limit the character length of a cell when typing
Macros don't run when editing a cell, so you would have to put up a userform
to receive the entry if you want that type of instant response (user enters in your textbox rather than in the cell). -- Regards, Tom Ogilvy "Andy" wrote in message ... Hi, I need to limit the number of characters (text and number, spaces excluded) that can be typed in, in a cell. Validation won't do for me because error occurs after pressing enter. I want to let users know that they cannot write more than certain characters in a cell as they write (forcefully stopping character input after certain number of characters). Please Help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Predefined Cell Character Length | Excel Worksheet Functions | |||
| setting a cell length limit | Excel Discussion (Misc queries) | |||
| assigning character length in a cell | Excel Discussion (Misc queries) | |||
| Character limit in cell | Excel Discussion (Misc queries) | |||
| Character limit per cell | Excel Discussion (Misc queries) | |||
Linear Mode
