a macro to find text based on user input

I am trying to create a simple macro that will find text based on user input. I tried recording a macro using the edit/find tool, but it won't let me go further with out entering the actual data. For example, I have a worksheet containing 1000 Last names, I want the user to be able to find any last name by entering a value as the search criteria.

I can write macros using the macro recorder, but may need more in depth help if the answer is visual basic.

Any help would be greatly appreciated!