+ Reply to Thread
Results 1 to 6 of 6

Looking for a way to generate a bunch of bar codes from a list of Excel checkbox

  1. #1
    Registered User
    Join Date
    01-23-2019
    Location
    Montreal,Canada
    MS-Off Ver
    2007
    Posts
    5

    Question Looking for a way to generate a bunch of bar codes from a list of Excel checkbox

    Looking for a way to generate a bunch of bar code from a list of Excel checkbox to later print and scanned into another system.
    It would look like this:

    Pick any item below

    Choice1,value ( )

    Choice2,value ( )

    Choice3,value ( )

    Choice4,value ( )

    Choice5,value ( )

    Choice6,value ( )

    Choice7,value ( )

    If any,or many choice(s) are selected a bar code would display on the right side and after the selection the user could print the page with the choices and the bar codes.
    Anybody have suggestions on how to do this? The bar code must be hidden if choice is not pick to avoid errors later.

    Thanks for your suggestions.

  2. #2
    Registered User
    Join Date
    01-23-2019
    Location
    Montreal,Canada
    MS-Off Ver
    2007
    Posts
    5

    Re: Looking for a way to generate a bunch of bar codes from a list of Excel checkbox

    Made a similar tread in EXCEL VBA, But If ACCESS could do that I am interested in knowing

  3. #3
    Valued Forum Contributor
    Join Date
    02-06-2014
    Location
    N/A
    MS-Off Ver
    N/A
    Posts
    373

    Re: Looking for a way to generate a bunch of bar codes from a list of Excel checkbox

    Hey-- To be honest, you're probably not going to find someone willing to do this one for free, it sounds like what you're asking for is for an enterprise application/use-case... if you're looking for a free-solution google is your friend.

  4. #4
    Registered User
    Join Date
    01-23-2019
    Location
    Montreal,Canada
    MS-Off Ver
    2007
    Posts
    5

    Re: Looking for a way to generate a bunch of bar codes from a list of Excel checkbox

    Spent few hours with my friend GOOGLE, could not find a way to actually do this in Excel, Just looking for hints, before purchasing ACCESS, or VB, or something else, I want to make sure it will work in the final !

  5. #5
    Valued Forum Contributor
    Join Date
    02-06-2014
    Location
    N/A
    MS-Off Ver
    N/A
    Posts
    373

    Re: Looking for a way to generate a bunch of bar codes from a list of Excel checkbox

    Yes, it's possible- I would start here: https://www.myonlinetraininghub.com/...with-excel-vba

    Once you understand how to generate the barcode, in the correct encoding for your use case, it shouldn't be too hard to automate it

  6. #6
    Registered User
    Join Date
    01-23-2019
    Location
    Montreal,Canada
    MS-Off Ver
    2007
    Posts
    5

    Re: Looking for a way to generate a bunch of bar codes from a list of Excel checkbox

    Great, I think this might work
    Thanks Poizhan for taking time looking into that, really appreciated

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Formula to Generate a list of codes
    By Animella in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 01-09-2014, 07:46 AM
  2. Using Formulas to Generate SKU codes
    By X-tremejoe in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-09-2013, 03:55 PM
  3. Using Formulas to Generate SKU codes
    By X-tremejoe in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-09-2013, 03:33 PM
  4. Getting trouble making codes for the buttons and checkbox
    By mariposa in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-06-2011, 07:09 AM
  5. checkbox codes
    By Jcanguy in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-08-2010, 12:49 AM
  6. How to generate a LIST from codes
    By bitswit in forum Excel General
    Replies: 8
    Last Post: 08-22-2010, 05:33 PM
  7. Creating a list, from data in a bunch of different files
    By Sibrulotte in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-25-2009, 05:22 PM
  8. How to generate a bunch of random numbers???
    By ddawg09 in forum Excel General
    Replies: 6
    Last Post: 03-12-2006, 09:40 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1