Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Formats - Limit # of characters
I want to limit the # of characters allowed in a cell to 11, regardless of
what the user types in (less characters is fine). How can I do this? -- KKD |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Formats - Limit # of characters
Do you want a message telling user he has exceeded the 11 characters and
make him do it over? Use Data ValidationText Length. You can truncate automatically to 11 or less using event code. No messages or do-overs. Private Sub Worksheet_Change(ByVal Target As Range) Dim oval As String On Error GoTo ws_exit: Application.EnableEvents = False oval = Target.Value If oval = "" Then Exit Sub If Not Intersect(Target, Columns("A")) Is Nothing Then With Target If Len(oval) 11 Then .Value = Left(oval, 11) End If End With End If ws_exit: Application.CutCopyMode = False Application.EnableEvents = True End Sub Gord Dibben MS Excel MVP On Thu, 1 Apr 2010 15:01:01 -0700, KKD wrote: I want to limit the # of characters allowed in a cell to 11, regardless of what the user types in (less characters is fine). How can I do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add a limit of 140 characters to any cell | Excel Discussion (Misc queries) | |||
Cell limit of characters | Excel Discussion (Misc queries) | |||
Can I limit a cell to 2 characters? | Excel Discussion (Misc queries) | |||
limit no of characters in cell | Excel Discussion (Misc queries) | |||
Can I limit a cell to 72 characters? How? | Excel Discussion (Misc queries) |