RE: design one event handler for multiple textboxes

Tech-Archive recommends: Fix windows errors by optimizing your registry

And also, in the Form designer, you can select all textboxes then set the
MaxLength property to 30 just one time.



--

Hope that helps.

Vergel Adriano


"Vergel Adriano" wrote:

Hi Clara,

Yes, you can set the MaxLength property by code. Put this in the
UserForm_Initialize sub

Dim c As Control
For Each c In Me.Controls
If TypeOf c Is MSForms.TextBox Then
c.MaxLength = 30
End If
Next c


--

Hope that helps.

Vergel Adriano


"clara" wrote:

Hi Vergel,

Thanks a lot for your help! Even the max length limitation can be done
through setting the corresponding property, but for 30 textboxes it is still
tedious, can you figure out a way to do it just in one time?

Clara
--
thank you so much for your help


"Vergel Adriano" wrote:

You cannot have one event handler for multiple controls.. at least not in
Excel 2003, not sure about 2007. The most you can do is put all the logic in
one subroutine and call that in the individual event handlers. However, for
the example that you gave, you can just set the MaxLength property of the
textboxes to 30.


--

Hope that helps.

Vergel Adriano


"clara" wrote:

Hi all,

In a form, there are 30 textboxes who all need the limitation of 30 chars in
length. I know code can be put in the change event, but if I do it in that
way, I will use 30 event handlers even I can abstract the core logic into a
sub.Is there a way to use one handler for all text box controls

Clara
--
thank you so much for your help
.

Relevant Pages

  • Textbox Maxlength not working
    ... I have many Textboxes that have the ... Maxlength property set to correspond with the length of the database ... however enter spaces using the space bar on the same keyboard (it beeps ...
    (microsoft.public.dotnet.framework.compactframework)
  • RE: design one event handler for multiple textboxes
    ... you can set the MaxLength property by code. ... Dim c As Control ... but for 30 textboxes it is still ... one subroutine and call that in the individual event handlers. ...
    (microsoft.public.excel.programming)
  • Re: Jump to next textbox upon character entering
    ... First of all set the MaxLength property to 1 ... if you want to move to the next control after one character is ... > I have a series of textboxes and each of them can contain one letter only. ...
    (microsoft.public.dotnet.languages.vb)
  • Textbox and maxlength
    ... I've a form in which there are a panel with a series of textboxes ... I need to change the maxlength property of each textbox depending on ... Dim ctrl As Control ... Instead if I use the name of the textboxes all work flawlessly. ...
    (microsoft.public.dotnet.languages.vb.controls)