barcode

  1. 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...
  2. 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...
  3. 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...
  4. 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
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. M

    Window / GUI lookup

    Hello - How can I get a window or GUI lookup in Excel? Sheet1 will have the lookup windows - Sheet2 the data table Also, for the input of the lookup, it would be great if it could conduct a fuzzy search. For example, 0346 is the input of the search and the output = the barcode for item #...
  10. M

    Calculate Check Digit

    Hi All, I think this should be fairly easy but I am just a bit of an issue getting a formula to work. I need to calculate a check digit for a bar code. The # is 3910037276 The instructions to figure check digit are as follows: Work with the leftmost 10 digits. Starting from the left take...
  11. D

    Excel help on testing an inventory

    I have an inventory of 550 emergency exit lights that must be tested every month. I'm finding my testers are not actually testing the lights but just checking them off on a printed spreadsheet. I want to install barcode stickers on the lights so they have to go to each light to verify...
  12. G

    EXCEL 2013 Sheet and blocks barcode

    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 ?
  13. I

    Change price to barcode ... easy breezy?

    I've created a form that prints out price labels. at the bottom of the form I would like to include the barcode corresponding to the price on the form as a label.caption so lblPrice.caption = variablePRICE I would like to take variablePRICE and assign its corresponding barcode to...
  14. C

    Barcode Scanner Macro

    I'd like to setup some sort of a macro in excel with a barcode scanner I have. We have a factory with a large number of machines which are all bar coded that also have travelers with the production order in a barcode format. Right now someone walks the line and manually writes which work order...
  15. N

    Using Macro Button to Change Print Area & Print out

    Good morning, I have a tracking file which automatically creates a new barcode each time a new line item is added. The barcodes are created in column 'BE' using the '3 of 9 Barcode' font. Beside each barcode in column 'BD' is a 'Print' button which I would like to be able to click and it will...
  16. G

    Scan barcode

    I have 20 workers , each with a barcode.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 ? Can it be done ? Thank you.
  17. N

    How to integrate a barcode scanner into excel (cells,sheet, etc.)

    Hi all, I bought a bar code scanner (a cheap one for 20 €). I would like to scan the barcode of the receipts and scan only date and total amount in predetermined cells. My question, is this possible with VBA? …without any extra software or costs. And if yes, how? …. Is there...
  18. G

    EXCEL 2013 Sheet and blocks

    EXCEL 2013 Sheet and blocksI need to count all blocks with the date and time in it as a unit in a block .F3 sheet Donnie and keep it up to count. This is what i have at the moment but need to add on it. I have two sheets , in sheet Donnie block A1 you scan a barcode , then it writes the...
  19. G

    EXCEL 2013 Sheet and blocks

    I need to count all blocks with the date and time in it as a unit in a block .F3 sheet Donnie and keep it up to count. This is what i have at the moment but need to add on it. I have two sheets , in sheet Donnie block A1 you scan a barcode , then it writes the Barcode in A1 sheet DDATA(2nd...
  20. K

    Copy barcode from excel to word not working

    I have a barcode in excel that scans just fine. Its code 3of9 extended. When i copy that cell and paste it into a word document it will not scan at all. Any ideas? Thanks Kris

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top