Hi Guys

Just a quick one I hope.

I have a user form that enters Part numbers onto a spreadsheet. I
enters the part numbers and the price onto the next available line.

These part numbers could have already been entered onto this shee
before.

My problem is two fold....

I need basically to find the best cost that is either the new entry o
any one of the existing entries for this part number.

1) So I need for the userform to either tell me that this part is ne
to the list..
as MSG box would do for this

Or

2) To enter the information and tell me that I have had a better cos
for this part before and to flag it.

Thanks

Either by showin

--
DB10
-----------------------------------------------------------------------
DB100's Profile: http://www.excelforum.com/member.php...nfo&userid=917
View this thread: http://www.excelforum.com/showthread.php?threadid=26541