I have a Userform that is supposed to take the input from a barcode scanner and then search through the previous logged items to find the cell that matches the number that the barcode scanner output. Right now I am having issues getting the userform number to match the list that is present in the whole sheet, I think it has to do with defining the userform value as a string or number, but I cannot figure out how to adjust that. I would also at some point like to make the Userform input automatic, so that as soon as you scan the barcode with the scanner, it will search and log the required information.
Solved by X. H. in 21 mins