Use the find method of the range object.

Beyond that, once you have the row, it should be similar to the Next code
you already have.
--
Regards,
Tom Ogilvy


"Cheryl" wrote in message
...
Good day..

I have a form that add/changes and deletes information with
first/next/previous and last record selectors. This is great and it works
(finally)... the next issue is.. How can I create a search form that has
criteria to search for a record such as search by Job Number .. so that it
takes the textbox criteria and goes to the named range on the excel sheet
(job number list) finds the first record that matches the Job Number and
displays it back in the user form so that information can be changed or
deleted. I guess similar to how worksheet change - advanced filter works
where I can enter criteria but .. for a User Form... There are too many
fields to do it just on a worksheet.. It displays neatly on a user form for
the person modifying the records. Could someone point me to an example of
this.. please. I have been searching but have yet to find a solution.. yet.