instead of

Cells(i,3).Value = Textbox3.text

do

Textbox3.Text = cells(clng(Textbox1.Text),3)

I assume you would have a separate button on the userform to retrieve data.

--
Regards,
Tom Ogilvy

"Newbie1" wrote in message
...
Help Im stuck again!!!

I am using a userform to enter details into cells to create an Excel
database.
Clicking a commandbutton enters the details from the boxes into the next
available row of the database. During this process column A of the row is
given a number.

I would like to be able to "re-use" the userform to recall any individual
row by the given number.
E.G. Enter the number into a textbox and the other text boxes of the
userform are re-populated with the other details from the row ---If
that
makes sense!

I hope somebody can understand and offer some help

Thanks

Kenny