+ Reply to Thread
Results 1 to 3 of 3

Prevent typing in a cell, but allow entr from barcode scanner.

  1. #1
    Registered User
    Join Date
    07-21-2014
    Location
    Wales
    MS-Off Ver
    2010
    Posts
    11

    Prevent typing in a cell, but allow entr from barcode scanner.

    Good afternoon.
    I have a spreadsheet that I use to validate the length of characters in a barcode label.
    The user needs to scan the barcode and then by using data validation it tests whether the correct no of characters are present in the barcode. If not an error message pops up saying the barcode is incorrect.
    I wish to prevent the user from entering (typing) anything in the cell manually.
    I need to be certain that data is only able to be entered by scanning the barcode. Otherwise they will add or delete characters to bypass the error.
    Is this possible ?

  2. #2
    Registered User
    Join Date
    10-18-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    67

    Re: Prevent typing in a cell, but allow entr from barcode scanner.

    how do you automate data to be entered into the cell from the barcode?
    is it a function in the Software that scans the barcode for you?

  3. #3
    Registered User
    Join Date
    07-21-2014
    Location
    Wales
    MS-Off Ver
    2010
    Posts
    11

    Re: Prevent typing in a cell, but allow entr from barcode scanner.

    (I believe the scanner is setup emulate a USB keyboard).
    At the moment I am using a handheld scanner to manually scan 2 barcodes
    Once for the model no (13 Char) and then for the serial no (17 Char).
    The data contained in the barcode is entered into a cells a1:b1, a2:b2 and so on.
    Column A accepts only 13 char, column B accepts only 17 char .
    If the both numbers are correct, a timestamp is added in column C the weeknumber in column D and the user in column E excel then proceeds to the next row.

+ 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. VBA Keylogger for barcode scanner
    By bgrillob in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-22-2014, 11:32 AM
  2. Barcode scanner in excel
    By amir8000 in forum Excel General
    Replies: 1
    Last Post: 06-03-2013, 08:30 PM
  3. [SOLVED] barcode scanner
    By metallicadad38 in forum Excel General
    Replies: 1
    Last Post: 11-09-2012, 04:55 AM
  4. Barcode Scanner
    By Rockhead_67 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 11-14-2011, 03:29 PM
  5. [SOLVED] Filling cell with color using barcode scanner
    By lg in forum Excel General
    Replies: 1
    Last Post: 11-23-2005, 09:00 PM

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