Just add:

SearchPartNum = UCase(SearchPartNum)

below the line:

Loop Until Not SearchPartNum = ""


This will convert all text inputted through the inputbox to capital
letters.

If you need anything else, write back.


--
kev_06
------------------------------------------------------------------------
kev_06's Profile: http://www.excelforum.com/member.php...o&userid=35046
View this thread: http://www.excelforum.com/showthread...hreadid=570599