enter data to a specific row

hello all, i have created a userform and i want to have a field where the user has to put the number of the row in which he wants to fill his data

Just add another textbox, check it has a value, and use that value.

Bob Phillips said:

Just add another textbox, check it has a value, and use that value.

Click to expand...

thank you for you resond, can you provide me with a code sample that does what you said, because honestly i am new to this

If you have created a userform, it must have some controls, this is just another one.

i understood what you said to create a textbox for the number of the row, but how to code that box to take this number and to copy the data that are entered in fields of the userform to that row
currently my code is looking for the first empty row, but i want to do it like i said before based on the row number