greg.begin
Member
I am using a scanner to scan barcodes on a list (items I am trying to find). I created a worksheet function using case select when case = $F$2, so when the user scans the barcode when the cell F1 is selected, it will execute. every barcode I see I scan and gotes through each one, one after the other. after I think I have scanned all items I was supposed to, I can take the items left over and put them into a missing sheet. so the remaining items get copied to another sheet called Missing. at this point I keep it so i know what I have to look for. Now, i am repeating the exact same process but now instead of the first sheet i am now in the Missing sheet. so when I scan the barcode the first time, the code executes, the second time, it doesn't fully execute. it looks as if it starts, then stalls and now the cell is F4 selected. after this, if I select F1 again, scan the barcode it will run, the next time it won't, then move it again and scan and the code will then execute. does any one know why it won't scan 2 barcodes in a row, when the first sheet did?