barcode

Hi, all! I've been doing some research on trying to have a macro function run when a barcode is scanned. The only ways I've been able to find online involve downloadable Add-Ins - is there anyway to do this without installing an Add-In? Thanks, as always, for all the help! Best, bob

Hi everyone, I am using Excel 2016 and am trying to create a macro worksheet for barcode scanners. Could anyone let me know if this is possible? (If not potential workarounds) I am a complete beginner to macro and any help would be greatly appreciated. How it will work is... 1. an employee...

I know that i can generate barcodes using the font; however, if i purchase a barcode reader is there a way to make it so that any employee(if i give each employee their own barcode) can sign out tools ( also using a barcode) and then sign them back in when done? I am basically wanting to create...

I created an inventory worksheet with userforms. Now I have a problem with VLookup command. I want the name of the item is shown in the "txtName" after I scanned the barcode in the "txt2DBarcode." Everything looks fine till I send the information. Then I receive an error. Run-time error...

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

I would like to scan a barcode label and input the value into cell A1. this input will be a 9 digit unique number. I would like to find the matching value in column B (about 9000 entries already entered) and highlight the row the matching value is found in. then, automatically return to cell A1...

Looking to write a formula that will tell someone which shelf to look for something based on the number. I have excel 2016 and thought of conditional formatting but I run out of colors or symbols to use. <tbody> Range shelf <colgroup><col><col></colgroup><tbody> 10049541...

Hi, There are many Android apps out there that track your comics/books/manga you have read. However I never quite found one that worked how I wanted it to or that tracked all 3 types of literature well. Therefore I built my own database in excel. So far it works pretty well for what I want but...

Hi Everyone, Let's open with "I Love Excel!" It's great and so powerful as long as you tell it correctly what you want it to do. And that's where I need your help... On a production line, we produce LH and RH parts, and apply a barcode label to each. Barcode labelling of the parts is not the...

Hi, everyone, I use library software that outputs a report as a text file with the information below for each Chromebook (item) that has been discarded in our system due to damage. These lines come into Excel on different rows in the same column. I need this information on a single row for...

Hi All, i am trying to set up a small system so i can scan a barcode from my android phone which then refers to a barcode master sheet (that i can replace at any time) to look up info and then puts that info ito a spreadsheet. info would be as follows in colums:- barcode, model, description...

I have 2 sheets in excel. 1 sheet is printed out for employee to sign and have an assigned barcode to there name. I want to scan that barcode and have it search for a match on the other sheet and highlight it. I am not using any barcode software just a usb scan gun. it will scan to the excel...

I've created a spreadsheet that uses the barcode font to create a barcode linked to specific data. The problem with this is that the sheet will be disseminated to users who likely will not have the barcode font installed on their computer. Anyone know of an alternative to this method that will...

I am very new to VBA, but I am writing code to populate a spreadsheet with data retrieved from a barcode scanner. The overall purpose is to manifest all products placed on a trailer. I have written code to create a worksheet for every PO #. I would like to shift or move between the worksheet...

Hello guys, I have a frustrating problem that I really need help on. Im using a user form in excel and integrated a Bluetooth barcode scanner which I scan barcodes into a text box. once the information is scanned into that text box the information goes into another text box below. The...

Hi, I got this code by searching on internet, and i use to count my store inventory by scanning there barcodes, We scan Barcodes in H1 cell, it searches that if barcodes list i pasted having the scanned barcode it increases the quantity of that item, if we scan a new barcode(not in pasted...

Hi All, I need a help with finding the solution for my Workbook. My file is used by many people in the company on different computers. I have to add an option which will be creating a barcode (preferred code128 but 39 will be good as well) in the worksheet base on the value in the cell...

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

Hello, I am trying to build a sheet to use as a job tracker. The company I work for produces art & photos on canvas, in frames. I would like to be able to use a scanner to input my data, such as Employee name, the job they are doing, Job Start, Job End and the quantity of products made. with a...

I've been trying to set up a spreadsheet that will have one cell that pulls data from a list in a separate sheet, and another cell that transforms the pulled data in to a barcode. I've got the right font, I've played with various formulas and macros, but every time I get this Untitled -...