1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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 :)
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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.
  16. 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...
  17. N

    Userform Textboxes values passing to a listbox

    Hello, Please I need your help. I have the link below for my shop workbook "example workbook" that contains a userform to manage my invoices I'm stuck in the following steps and don't know how to solve them, and need your help if you may In TextBox "txtBarCode", If I search for an item by...
  18. U

    Scan All Product Data into Excel Using the Barcode

    I would like to know if this is possible. You can use Excel to scan in a Barcode from various products, it scans into a cell and either you autotab or click to the next cell to get the next barcode. When you sell a product like books you notice that certain data is consistant accross related...
  19. N

    Simple String question

    I'm currently using a barcode scanner to input values into an excel sheet. the barcode contains values such as: C000111254|HPSSF2517|14NIZE C000098567|HSCF21|22BRSS etc. The beginning and end string length will always be the same. 10 characters and 6. the middle set will vary in length. I...
  20. B

    barcode and description

    hi im scanning barcodes into A column and want b column to put description of item in column in B I am trying to create a inventory sign out, sign in page for search and rescue Thanks Barry
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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