+ Reply to Thread
Results 1 to 2 of 2

VBA barcode scanning

  1. #1
    Registered User
    Join Date
    Melbourne, Australia
    MS-Off Ver

    VBA barcode scanning

    Hi there,

    I'm trying to code a spreadsheet to recognise codes scanned by barcode scanners. It would need to recognise one form of code (a letter followed by three numbers eg. A111), locate a cell with the matching code in it and select the cell to the right in the same row. Then with all other codes varieties, it would need to record that code into selected cells. Please help :-)

    Thank you all! Have a lovely day.

  2. #2
    Forum Contributor
    Join Date
    MS-Off Ver
    Office 2003, 2007 & 2010

    Re: VBA barcode scanning

    Assuming your code is entered into cell A1, your barcode lookups are in cells B1:B10 and the matching codes are in C1:C10, put this formula in a cell on the same sheet;

    Please Login or Register  to view this content.

+ 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. [SOLVED] Check barcode scanning
    By intex in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-25-2015, 02:23 PM
  2. [SOLVED] Issues with barcode scanning
    By qmccain in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-31-2015, 01:34 AM
  3. VBA to look up part number when scanning a barcode
    By Drake2007 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-14-2014, 06:29 PM
  4. barcode scanning template
    By donkey_uk in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-16-2013, 12:19 PM
  5. Barcode Scanning - Library
    By _LG_ in forum Excel General
    Replies: 1
    Last Post: 12-05-2011, 11:55 AM

Tags for this Thread


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