barcode scanner

Hi, I have a simple userform (for now!) that has two fields/textboxes on it that need to populate when a barcode is scanned. Problem I have is that I need to populate both with a barcode, mainly for speed, although a user could still type in if they wanted or needed to. One scan would be...

I am attempting to detect if a barcode scanner input is used (as opposed to manual input), and if it is I would like an event to trigger that selects the next available (empty cell) in the correct column (if a barcode is being scanned into the wrong column for instance). Is it possible to...

Thanks for adding me - first post, lets hit the ground running Here is what I am working with. 1.. Barcode / SKU scanner. 2 .. Excel Master Data List (all on one tab/sheet) Here is what I am able to do now. Take the scanner, scan a barcode on a product, excel finds that item and highlights the...

Hello all, Looking for a simple VBA script that will allow to the scan 5 barcodes (A1 thru A5) then return to the next row......

Hi all, i have a userform in excel which i want to use a barcode scanner to enter data so that there are no errors. For textboxes, the barcode scanner works fine. However in a combo box that I have, the barcode scanner enters the correct text but then instantly wipes it out Is there anything i...

I need to do inventory using a barcode scanner and excel. How do I make it so after I scan it the program will search the old inventory spreadsheet for the matching barcode and copy the barcode as well as the adjacent cells (with the item names and serial numbers) into the new spreadsheet. I...

Hello Friends, New here and in need of assistance. I am recently facing a problem where I need to confirm the number of items received against supplier provided document. To make it clear, I have a excel sheet containing 10 barcodes for 10 boxes. I want to program my Excel file in such a way...

Hello. i got a question about barcode scanner.. when i scan a number with the barcode scanner my macro`s arent working..? but the formula`s are working.. i cannot link the sheet i`m working on since its a invalid file.. but i will link the macro i am using, and link a picture of what`s not...

Barcode scanner, 60 sheets. I need the active block to be A1 on a specific sheet . So if Paul scans his barcode i need the active block to go to his sheet, and if john scans his barcode i need the active block to go to John s sheet A1 ?

Hi Introducing myself, my skill in Microsoft excel is very basic. So my coding skill is minimum. I am creating a simple system to track collection Tin time In and Out. Below are the concept. The tin number is fixed and is converted into barcode. When I press on the Time Out button, and scan...

Hello, I am currently working on a project where I will be inventoryingan Evidence Room for a client. The clientwill be providing me with a list of itemsthat are supposed to be in the propertyroom. I will then scan all the items in the property room and then run queriesagainst the known list to...

Hello There! I'm looking for a solution to my problem and have not found anything online, so I'm coming to you. So, this is what I'm looking for: The barcode scanner I have is a keyboard type and works well with Excel, but... 1. When scanning a barcode, I want ActiveSheet to...

Good Morning Everyone (at least whenever I am first posting this), I have made a barcode scanner userform that acts as a small inventory system for my company. Nothing special but it gets the job done. Basically the inventory employee would scan a specific parts' barcode, and a TV display will...

Hi all, I work for a small manufacturing company, and I have been tasked with setting up a barcode system. I am not trying to setup an inventory management system, I do not need to keep track of any quantities (or at least as of right now). I could see the system wanting to be expanded into...

Dear all, I have a worksheet where I read an external barcode and then I set a cell to write the same barcode as the one I have read. Well, what I need it is a code to print the specific ranges of cells ( or the whole sheet) where the barcode is written right after I read it with the scanner...

I have been tasked with a project to create an Excel sheet for Stock Purposes. I have a Wired Handheld Scanner, and I have been able to scan a Barcode to Excel, and for it to show up in the selected Cell. I have the following Columns in my Excel Sheet; Column A = Barcode (in text form) Column B...

I have many items with bar codes on carts which also have bar codes. Every once in a while, I use a bar code scanner to scan what is on all of the carts. When I do this, the data is input in excel looking like this: B T1152567857 T1134567846 T1435678935 T1164536223 C T1678245534 T5674839298...

Hi, i was wondering if anyone knew how to or if it is possible to set a scanner to scan barcodes into a specfic sheet, column or row in excel whole cursor is on another? Meaning you would set the scanner to scan the barcode in spot and could be working on the document somewhere else - currently...

Hi Experts, This is my first post here and I hope this would be more interesting for Excel VBA Geeks like you all. Ok, here is my (problem) description: I have created a new Excel VBA application, which will accept a number (Ex: 59745-7845-5412). Once the user clicks on the Fetch button after...

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