| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to set text length in cell
I need to be able to control the text length in either a cell or in a group
of merged cells (i.e. E22:G24, but merged). Data Validation doesn't return an error message until you hit the enter button. I would like something to return an error message if, for example, the maximum length is 20, then when the 21st character is hit, the message box pops up. Is this possible? -- Sandy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell text length conditional formatting - Excel 2003 | Excel Discussion (Misc queries) | |||
| Summing a column based on the length of text in a cell in anothercolumn | Excel Worksheet Functions | |||
| Zip Code Validation - length =5 or 9 | Excel Discussion (Misc queries) | |||
| How do I set up a text cell in Excel with restricted length? | Excel Discussion (Misc queries) | |||
| The text length versus the cell size... | Excel Programming | |||
Threaded Mode
