Mutiple text Boxes

[AlexanderBB]

If my form has eight text boxes, and I want six of them to run the same Keypress, AfterUpdate and Change events, do I need to repeat
the code for all six?

 

[Sektor]

You could do something like this. Create general procedure which will handle events for required textboxes:

Private Sub TextBox1_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger)
  Call TextBoxKeyPressHandler(TextBox1, KeyAscii)
End Sub

Private Sub TextBox2_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger)
  Call TextBoxKeyPressHandler(TextBox2, KeyAscii)
End Sub

Private Sub TextBox3_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger)
  Call TextBoxKeyPressHandler(TextBox3, KeyAscii)
End Sub

Private Sub TextBoxKeyPressHandler(textBoxCaller As MSForms.TextBox, ByVal KeyAscii As MSForms.ReturnInteger)
  '// do something
End Sub