limit text lenght
Visual Basic
2
Posts
2
Posters
0
Views
1
Watching
-
This is to all the excel geniuses, am trying to limit the lenght of text in a dailog box(in excel) if you think u can help plz reply Thanks :confused: :confused:
-
This is to all the excel geniuses, am trying to limit the lenght of text in a dailog box(in excel) if you think u can help plz reply Thanks :confused: :confused:
I assume you are using a textbox. Just set the MaxLength property to the length you need. You can do this in the properties window (right click the text box and select Properties) or in code (Userform1.Textbox1.MaxLength = xx in the initialize procedure).