Hello I am new here and very new to VBA,
I have a userForm with multiple textboxes referencing cells on a worksheet. Due to the vast number of Textboxes and cells, is there a method for the below code to be simplified, opposed to typing out 125 lines of similar code. Thankyou for any help.
I have a userForm with multiple textboxes referencing cells on a worksheet. Due to the vast number of Textboxes and cells, is there a method for the below code to be simplified, opposed to typing out 125 lines of similar code. Thankyou for any help.
Code:
Private Sub BtnUpdate_Click()
Sheets("Sheet1").Range("A1") = TextBox1.Text
Sheets("Sheet1").Range("A2") = TextBox2.Text
to...
Sheets("Sheet1").Range("A125") = TextBox125.Text
End Sub