Using barcode scanner to FIND corresponding cell/value

Hello,

I'm wondering if there's a way to use a barcode scanner to FIND a value that already exists in an excel file, instead of only inputting the values retrieved from the scan??

For context, a program exports data into an excel file. This data is what is encoded in the barcodes. I want to find where/which cell that exported data went to. There is a long list, so finding a number manually can be difficult when they are all 5-digit numbers that were all exported.

Thank you!!

Originally Posted by shg

How about Ctrl+F?

I would like to scan the barcode and it to be found automatically. Trying to used the keyboard as less as possible.

Originally Posted by shg

You can use the worksheet change event to find the value when the barcode is entered. You haven't provided enough information to make a more specific suggestion.

What is a worksheet change event? Sorry, I don't know enough about excel to be very specific about this.
I would just like to scan a barcode, and for it to highlight the cell consisting of that value.
For example, a barcode codes for "12345"
If I scan this barcode, the cell that contains "12345" will be found and highlighted within a list of other 5-digit codes.

Originally Posted by shg

What column does the barcode get scanned into?

In other column are the other numbers?

How about posting a workbook with an example?

I don't want the barcode to be scanned into any column. But if it has to be, that's fine but I will delete it later, so any column is okay.
I have attached a workbook as an example.
The barcode would match with a number in column B.

How can i modify above VBA scrip to search in whole excel sheet ? Empty cell for search input would be A3

labtech14 were you able to find a solution for your demand? I have an identical need: scan a barcode and for it to highlight the cell consisting of that value

also looking for assistance in this...My Eq. starts in B5-B95 and my bar codes are generated in J5-J95 using the EQ. # in B5-B95 and I want to use L5-L95 as my scan to location. I would like to be able to scan a random EQ# and have it show in the appropriate J5-J95 location.

Hello
I have a similar query for my stock management.
I have an excel workbook containing various sheets of different category of items with products under each for which barcodes are mentioned in column A.
I want to find a solution where i scan any random product in my store using a barcode scanner, it should locate the barcode and automatically format the relevant cell by adding fill colour or changing the font colour.

FIND & REPLACE OPTIONS IS SUITABLE BUT IT NEEDS TO BE MANUALLY MANAGED BY CLICKING THE REPLACE BUTTON AND THEN AGAIN SELCTING THE TAB FOR NEXT FRESH SCAN.
KINDLY SUGGEST ANY OTHER WAY

Find attached the sample excel sheet for reference. the excel has 3 sheets of different categories of items, i want to scan any random item using barcode scanner and the scanned barcode is highlight using fill colour green.

Thank you in advance

Originally Posted by fabitocruzjr

labtech14 were you able to find a solution for your demand? I have an identical need: scan a barcode and for it to highlight the cell consisting of that value

hello
where you able to find a solution for the query