"FIND" Macro in Excel

This ought to be an easy one.
I've learned VB by playing around, so
forgive my archaic ways.

I have a simple database of codes with cross reference to their
descriptions and the date they were issued.. I want to
create a user-interface macro allowing someone to put in the
code they want to cross reference (rather than search by filter) and have excel
display the data.

Here's what I've got so far, keep getting errors at the line that begins with
.find:


Sub findthis()
Dim MyValue, MyFindNext
Range("b1:b9999").Select
MsgBox [Type in what you are Searching for.]
.find = (MyValue)
LookIn:=xlFormulas,
LookAt:= _
xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext,
MatchCase:=False).Activate


Is there somewhere in excel that will define the commands I need to use?

Many thanks for any input.