1. S

    Help Required With Barcode Being Read Into A Userform...

    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...
  2. Nikkolas Camp

    Custom Barcode Inventory System Using Excel

    So, I'm wanting to build a custom inventory spreadsheet to better track out material in house. We have a process to tracking our inventory, it being tracked in total square yards. We currently do our inventory the old fashion way, that being with our trusty pencil and paper, read all tags...
  3. R

    Macro Help (Barcode Scanner to Excel Sheet)

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

    VBA to create printable Barcode sticker labels from Excel

    I am trying to generate printable stickers from Data I have in Excel. I currently have 4 columns of Data, Columns A and F are the values and C and H Barcodes were generated from Columns A and H: The problem I have is trying to format and mass generate printable Barcode sticker labels from...
  5. M

    Using Word Mail Merge to create Barcode sticker labels from Excel

    I am trying to generate printable stickers using Mail Merge from Data I have in Excel. The Data I have: Using Mail Merge it turns into this as the Font changes from Code 128 in Excel and into Calibri in Word: Ideally, I would like it to look like the first record automatically but I had to...
  6. B

    Combo box + Barcode Scanner

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

    VBA to Automate the Delimiter

    I'm attempting to find a solution to automate the delimiter and I've scoured the forums and internet to no resolve and was hoping I may be able to find an answer here. Right now I am having excel generate a barcode in the example format of "11D*122*1", each identifying number is split by the...
  8. N

    Use barcode to search sheet and check in with date and time.

    Hello I have seen similar questions on this forum but can't find one that addresses a part of my question so i wondered if anyone could help. I regularly receive large numbers of items into work and have a barcode scanner to check the items are there on the excel sheet. At the moment i use...
  9. G

    Excel/Sheets - ISO Solution

    Hello all, I'm trying to improve the inventory management process at work, currently we're tracking everything through manual input (handwritten) using a form and then we put any relevant information on a sticky note and post it to the box. These boxes come in from numerous different places and...
  10. Y

    Barcode Scanning in the Userform (missing numbers.)

    Hello everyone my problem is a little bit annoying. When i try to scan a barcode in the textbox there is always number 7 is missing. for example if the barcode is 123456789 it writes in the text box 12345689 . The barcode scanner works perfect except in the userform. I tried in the notpad it...
  11. I

    Bespoke barcode code.

    Basically, looking for a start point with this project and what would be the most effective way of achieving it. I've attached an image of the outcome I'd like to achieve. I'll have a print out of all these barcodes and what I want to occur is that when I scan for example barcode 1 is it will...
  12. R

    enter quantity window pop out after barcode scan

    Hi. im working on an inventory system using excels sumifs function. in/out so i was wandering is it possible to have like pop out window/ when i scan a barcode in "IN" or "OUT" sheet a window will pop out saying to enter qty? thanks :)
  13. slave1spectre

    Scan against X in cell when matched...automated

    <a href="" target="_blank"> Hi All, Please bear with me as I am not a programmer and therefore aren't fully competent with the terminology or...
  14. kelly mort

    QR code to load a static barcode control on a worksheet

    I have this code here, to create qr code. It's doing well getting the code. But I am thinking of having a pre-created barcode control, where I only run the code to load the control instead of creating new one each time. Maybe, the sheet change event will do the job. But since this object is...
  15. N

    VBA Code to insert the same data for many clients!!

    Hi, I have a userform with many controls, and below are some of them txtBarCode (TextBox) [where I insert the needed Item's Barcode] cmbNum (ComboBox) [(List from 1 to 8) to Identify the clients number] txt_Name1, txt_Name2 ...txt_Name8 (TextBox) [To insert the client names, (if cmbNum = 3...
  16. HappyChappy

    Barcodes in Excel

    Hi having great problems with bar codes currently using a web based site to generate barcodes then cutting and pasting them into excel as a picture. The site uses Code 128b for the fonts. I downloaded said font and thought it must be better to do...
  17. H

    Problem scanning data from a barcode reader into excel

    Hi all, I have a vexing problem. I have a Toughbook CF-H2 Toughbook running Windows 7 pro with service pack 1. The unit has a built in barcode scanner. It scans a barcode perfectly and inputs the number into Word, Word Pad, or a text document but when I try to scan the barcode directly into...
  18. A

    Auto Print after scanning in 7 digit barcode

    Hey guys, I am wanting to print a label automatically after user scans in barcode in A1. The code I am using is If Intersect(Target, Sheets("Sheet2").Range("A1")) Is Nothing Then Exit Sub Else Application.EnableEvents = False If Len(Target.Value) = 7 Then...
  19. G

    BarCode Scanner

    Hi Everyone, I am trying to scan the barcode and that barcode value should display/print in excel column 'C' , can this be done using excel Can anyone suggest me, how this can be done. Regards, Dhruva.
  20. N

    Search manually from sub_Change

    Hello, I have a userform with a lot of textboxes, one of these textboxes is "txtBarCode" that allows me to enter any Barcode to check if the item is exist or not and lookup values for "txtItemName" & "txtPrice" and I have the code below that works very well But, sometimes I need to enter the...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back