+ Reply to Thread
Results 1 to 14 of 14

Using barcode scanner to FIND corresponding cell/value

  1. #1
    Registered User
    Join Date
    11-14-2017
    Location
    Canada
    MS-Off Ver
    2013
    Posts
    6

    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!!

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,677

    Re: Using barcode scanner to FIND corresponding cell/value

    How about Ctrl+F?
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    11-14-2017
    Location
    Canada
    MS-Off Ver
    2013
    Posts
    6

    Re: Using barcode scanner to FIND corresponding cell/value

    Quote Originally Posted by shg View Post
    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.

  4. #4
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,677

    Re: Using barcode scanner to FIND corresponding cell/value

    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.

  5. #5
    Registered User
    Join Date
    11-14-2017
    Location
    Canada
    MS-Off Ver
    2013
    Posts
    6

    Re: Using barcode scanner to FIND corresponding cell/value

    Quote Originally Posted by shg View Post
    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.

  6. #6
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,677

    Re: Using barcode scanner to FIND corresponding cell/value

    What column does the barcode get scanned into?

    In other column are the other numbers?

    How about posting a workbook with an example?

  7. #7
    Registered User
    Join Date
    11-14-2017
    Location
    Canada
    MS-Off Ver
    2013
    Posts
    6

    Re: Using barcode scanner to FIND corresponding cell/value

    Quote Originally Posted by shg View Post
    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.
    Attached Files Attached Files

  8. #8
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,677

    Re: Using barcode scanner to FIND corresponding cell/value

    In the sheet module for AG,

    Please Login or Register  to view this content.
    Scan into B2 on that sheet.

  9. #9
    Registered User
    Join Date
    11-07-2018
    Location
    Riga, LAtvia
    MS-Off Ver
    2016 (o365)
    Posts
    1

    Re: Using barcode scanner to FIND corresponding cell/value

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

  10. #10
    Registered User
    Join Date
    02-28-2020
    Location
    Brazil
    MS-Off Ver
    MS Office 10
    Posts
    1

    Re: Using barcode scanner to FIND corresponding cell/value

    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

  11. #11
    Registered User
    Join Date
    03-03-2020
    Location
    england
    MS-Off Ver
    MS Office 365
    Posts
    17

    Re: Using barcode scanner to FIND corresponding cell/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.
    Attached Files Attached Files

  12. #12
    Registered User
    Join Date
    08-17-2021
    Location
    Hyderabad, India
    MS-Off Ver
    mS office 2019
    Posts
    2

    Re: Using barcode scanner to FIND corresponding cell/value

    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
    Attached Files Attached Files

  13. #13
    Registered User
    Join Date
    08-17-2021
    Location
    Hyderabad, India
    MS-Off Ver
    mS office 2019
    Posts
    2

    Re: Using barcode scanner to FIND corresponding cell/value

    Quote Originally Posted by fabitocruzjr View Post
    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

  14. #14
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    20,831

    Re: Using barcode scanner to FIND corresponding cell/value

    Quote Originally Posted by akshay1307 View Post
    Hello
    I have a similar query for my stock management.
    As a new member, your first visit should be to our rules. There aren't many, and they are all important. We ask that you not add a new question to someone else's question.

    Administrative Note:

    Welcome to the forum.

    We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

    Please see Forum Rule #4 about hijacking and start a new thread for your query.

    If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 03-17-2017, 10:52 AM
  2. Barcode scanner help
    By abirup in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-19-2016, 05:43 AM
  3. Replies: 2
    Last Post: 03-23-2015, 10:04 AM
  4. use my barcode scanner to add or subtract and find items in my spreadsheet
    By flaflash64 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-20-2015, 03:40 PM
  5. barcode scanner
    By metallicadad38 in forum Excel General
    Replies: 1
    Last Post: 11-09-2012, 04:55 AM
  6. Barcode Scanner
    By Rockhead_67 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 11-14-2011, 03:29 PM
  7. Filling cell with color using barcode scanner
    By lg in forum Excel General
    Replies: 1
    Last Post: 11-23-2005, 09:00 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1