Results 1 to 2 of 2

Thread: Using a barcode scanner with Excel

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Using a barcode scanner with Excel

    Hi All,
    I am looking at a way to use a handheld bar code scanner and input the data into a worksheet.
    What i need to do is the following
    1: Scan cabinet serial number into cell C3 (9 characters in total for serial number)
    2: Scan module 1 serial number into Cell D3 (12 characters in total for serial number)
    3: Scan module 2 serial number into Cell E3 (12 characters in total for serial number)
    each time the serial number is scanned i want to automatically jump to the next column and enter the serial number and jump to next column

    once i have those 3 items scanned i then want to jump down to the next row and continue doing the same.

    I know there has to be some VBA code here but i have no clue where to start.

    Can someone help me out please
    Last edited by Mr_Mod; 05-12-2016 at 05:49 AM.

Posting Permissions

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