| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Limit textbox to 255 characters
Hi I have a textbox that user types in a comment and I want to limit the
input to 255 characters. I am using code as below but when I try to remove the extra characters I get an error can some help please. TIA Charles Select Case Len(TextBox1.Value) Case Is = 255 MsgBox "You Have Reached The Input Limit Of 255 Characters" Case Else lblCounter1.Caption = "Characters remaining " & (255 - Len(TextBox1.Value)) End Select |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Limit textbox to 255 characters
Sorry I have worked it out by using the Mid function.
Regards Charles "vqthomf" wrote: Hi I have a textbox that user types in a comment and I want to limit the input to 255 characters. I am using code as below but when I try to remove the extra characters I get an error can some help please. TIA Charles Select Case Len(TextBox1.Value) Case Is = 255 MsgBox "You Have Reached The Input Limit Of 255 Characters" Case Else lblCounter1.Caption = "Characters remaining " & (255 - Len(TextBox1.Value)) End Select |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Limit textbox to 255 characters
Hi,
You could use the textbox property "Maxlenght". Regards JY "vqthomf" wrote in message ... Hi I have a textbox that user types in a comment and I want to limit the input to 255 characters. I am using code as below but when I try to remove the extra characters I get an error can some help please. TIA Charles Select Case Len(TextBox1.Value) Case Is = 255 MsgBox "You Have Reached The Input Limit Of 255 Characters" Case Else lblCounter1.Caption = "Characters remaining " & (255 - Len(TextBox1.Value)) End Select |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Character limit in textbox | Excel Worksheet Functions | |||
| Limit Number Of Characters Allowed In A TextBox | Excel Programming | |||
| limit character in textbox | Excel Programming | |||
| Limit input in a textbox | Excel Programming | |||
| UserForm TextBox to ActiveSheet TextBox over 256 characters | Excel Programming | |||
Linear Mode
