Search Button - Finds Part Numbers with numbers, letters and characters

Hi Everyone,

I currently have a Userform that you type a part number in, which can include letters, numbers, characters (mainly -,*). When clicking the command button with the magnifying glass, it will search the part number in the 'RI PN Info' spreadsheet and pull the appropriate data into the correct textboxes. Unfortunately, it is not working on part numbers with characters in them. Can you please help. Here is part of the code for quick reference.

Please Login or Register  to view this content.