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

    Excel Barcodes substract or add number

    Hello, Curently I have this: <tbody> Item Stock Barcode ADD BARCODE SUBSTRACT Samsung Galaxy TAB s3 5 Datalogic PBT930 2 </tbody> So I have created barcodes and inserted them in the barcode add and barcode substract field. Each barcode has a different value. What I want to do is...
  18. N

    Barcode System for Checking In and Out

    I am writing a macro in VBA for an excel spreadsheet to manage barcode sign ins for a summer camp program. Column A is Last Name Column B is First Name Column C is ID Number All other columns will be alternating between AM check-in and PM check-in This issue I am having that, upon scanning...
  19. N

    VBA for Macro Button

    I'm not overly knowledgeable when it comes to VBA so I'm hoping someone can write me a quick VBA for this purpose. I have a long list of items in a tracking file, each line-item has a barcode in column D and a macro button beside each barcode in column E. I need a VBA code so if I click on the...
  20. N

    Creating a Macro Button to Print Specific Cells

    I need to create a "print" button using ActiveX (Our company blocks the other macro button) to print off a specific cell containing a barcode. The document is a tracking file so when each line item is filled out, it generates a barcode. Beside each barcode, I want a macro button of some sort...

Watch MrExcel Video

This Week's Hot Topics

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