UserForm Entering Data Into Excel Rows

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.

Please Login or Register  to view this content.

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!

How is the ID selected?

Please Login or Register  to view this content.

Thanks for the reply, I'll try out your code.

So the user should know the ID and input that into the UserForm, along with the additional information. My code currently doesn't do anything with the ID, but it should ideally match the input with the row, and automatically insert the additional information. Does that answer your question?