Hi everybody,
please can anyone guide me as to how to search for and edit a row using the user form created for entering the data

i have created the user form that enters new data to the last clear row, but I need to be able to locate a specific row and edit the data.

i have searched and searched for this but to no avail, I have a book " excel vba 24 hour trainer" and although can now manage most of the exercises, it does not cover search and edit.

I have three columns, ref number, works, date, the user form has three text boxes to insert this data, of which i enter the first two. and need to recall the ref number later to insert the date.

i hope this is clear, I have thought of many complicated methods of doing this, but would be grateful if anyone has experience, or can just help me out.

many thanks
may I take this opportunity to thank everyone on the forum that has helped me in the past, and all those that help us newbies!!!
Rob