Hello
Is it possible to activate some code whenever anything or a selected bunch of textboxes change?
So instead of using this code 15 times:
Private Sub txtPTno1_Change()
Sheets("Personal Tax").Range("C2").Value = txtPTno1.Value
End Sub
I could use something like:
Private Sub frmQuote_Change()
Dim x As Long
For x = 1 To 15
Sheets("Personal Tax").Range("C" & x).Offset(x - 2).Value = Me.Controls("txtPTno" & x).Value
Next x
End Sub
I only ask as my UserForm may end up having lots of these little bits of code, with the only differences being the numbers.
Bookmarks