*the line of code: if n < "" then...* (I hope my logic is correc
here)

The aboce like of code is used to check the range of column "F, Row
27-307" for a Customer SSN, some of the cells have Customer SSN's
other cells in that range may be blank because not all of the custome
records have been added to the file yet. Someday the Rows may go wel
past 307 records.

Yes, The idea is that the End User will enter a customers Socia
Security Number, and click the command button cmdSelectRecord.

Once the command button is clicked, Im trying to search for the use
inputed SSN in column F (A customized form, and text box is used by th
end user to retreive the SSN that we are searching for) .

Once I find that Customer SSN, I then want to retreive othe
information on that customers record

--
Mcastee
-----------------------------------------------------------------------
Mcasteel's Profile: http://www.excelforum.com/member.php...fo&userid=1569
View this thread: http://www.excelforum.com/showthread.php?threadid=27258