Thousands of sites with code examples for everything. Just google with excel VBA as leading search terms. And VBA has an excellent help.

http://www.excel-vba.com/v-input-box.htm discusses the input box. Then select column A and use the Find (and findnext) method on this range to search for what's entered. For help, just type Range("A1").find, then position your cursor on find and press F1.

Just the big line, this. Will certainly need some work and finetuning.

Here's a far more complicated example: http://www.vbaexpress.com/kb/getarticle.php?kb_id=195
Just strip it to what you need. Or google further than I did.

Hope this helps.


Kees