+ Reply to Thread
Results 1 to 4 of 4

Barcode 128 vba code not creating accurate codes.

  1. #1
    Registered User
    Join Date
    10-03-2023
    Location
    Binfield
    MS-Off Ver
    365
    Posts
    2

    Post Barcode 128 vba code not creating accurate codes.

    Hi,

    I have been trying to implement a new sheet where Text asset numbers in one column are passed to the next column over and displayed in the unhidden ASCII code representation.
    This ASCII code is then passed to a VBA module which I got pre-coded from the web and appends the correct start and end codes and then prints the correct Barcode128 back in the
    next column over. I just cannot get it to work correctly and no matter what format I change the different cells to it will a) not show the ascii code and b) not generate the correct Code128 image

    Could someone please look over attached file to see where I am going wrong please
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    10-16-2023
    Location
    Poland
    MS-Off Ver
    Excel 2019 32bit WIN10
    Posts
    88

    Re: Barcode 128 vba code not creating accurate codes.

    Change the name of the module from "Code128" e.g. to "modCode128" and change the format of the "Barcode" column to "General" and re-enter the formula.

  3. #3
    Registered User
    Join Date
    10-03-2023
    Location
    Binfield
    MS-Off Ver
    365
    Posts
    2

    Re: Barcode 128 vba code not creating accurate codes.

    Thank you so much Tajan, That worked perfectly. Im' guessing the software was getting confused with the module name being the same as the Sub-name ?

  4. #4
    Registered User
    Join Date
    10-16-2023
    Location
    Poland
    MS-Off Ver
    Excel 2019 32bit WIN10
    Posts
    88

    Re: Barcode 128 vba code not creating accurate codes.

    Yes. This was causing a problem.

+ 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. Replies: 6
    Last Post: 07-04-2020, 12:42 PM
  2. QR Code vs BarCode
    By renrut_5 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-20-2020, 07:03 AM
  3. [SOLVED] Creating a valid barcode formula
    By Equinoxseven in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 05-16-2017, 02:12 AM
  4. Replies: 7
    Last Post: 08-13-2015, 10:58 AM
  5. Replies: 3
    Last Post: 12-16-2014, 07:05 PM
  6. Creating Macro for Barcode printing
    By murerapp in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-18-2014, 11:32 PM
  7. Replies: 1
    Last Post: 08-21-2013, 03:23 AM

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