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
HI, I am trying to figure out how to make a search macro is Excel which will pop up a box which asks the user for the search critera. It will then go into Column A only and search there. Any idea's? The excel version is 2000

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic