Hello everyone!

I have a dataset with a long list of Rows, with Column headers that contains ID numbers and some ‘other information’. I currently have a UserForm created that has text boxes which ask the User to input the ID number they are looking for, and the ‘other information’ they would like to update into the dataset. What I would like help on is the code for the command button that would find the ID number under the column header, and to automatically transfer the ‘other information’ the user inputted into the same row (the one that matches the ID number).

I currently have a rough start; my code only transfers the UserForm inputs into the next empty rows.



Private Sub cmdUpdate_Click()

Dim eRow As Long
Worksheets("Sheet3").Activate
eRow = Worksheets("Sheet3").Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row
Cells(eRow, 3) = TextBox1.Text
Cells(eRow, 7) = TextBox2.Text
Cells(eRow, 8) = TextBox3.Text
Cells(eRow, 11) = TextBox4.Text

End Sub

I would my code to transfer the UserForm inputs into the column that match another ID that is in the existing row. To illustrate, under Column A, I have thousands of ID numbers that are already listed. I want the UserForm to update information to the correct row identified by the unique ID number.


Any help would be greatly appreciated!