I have created a custom user form to input data. Now I
need a macro that will search column A for example for
the value which is input into text box 1, and
furthermore, if the value entered in text box 1 is found,
I need the cell values for that specific record to be
displayed in the various text boxes on the user form for
editting, like for example I have a user form:

User Id, user name, user city
123, bob, kansas city

I need to search for 123 and return all values (123, bob,
kansas city) to text boxes on the user form so I can edit
them and ultimately save the changes.