Reducing Code

  • Thread starter Thread starter Garry Jones
  • Start date Start date
G

Garry Jones

I have hundreds of text boxes on a user form.

For each text box I need to run the following traps on Exit and
BeforeUpdate to check user input and reset to old input if new input
does not meet requirements. I know I can run these traps as private
subs. By returning True or False I can trap the user or allow user to
continue inputting in the next text box.

This all works..
________

Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
Cancel = Chkinp(TextBox1)
End Sub
_________

________

Private Sub TextBox1_BeforeUpdate(ByVal Cancel As MSForms.ReturnBoolean)
Cancel = Chkinp(TextBox1)
End Sub
________

Must I duplicate the code for every TextBox? Or is a way to use "For
Each" or a variable? If this code exists where would I put this so it
would be valid for the entire user form. (ie without creating two new
Private Subs for every text box).

Garry Jones
Sweden
 
For each textbox, for the exit and beforeupdate events, you would need
separate events for each textbox.
 
Back
Top