VBA to create printable Barcode sticker labels from Excel

[Matty Se]

I am trying to generate printable stickers from Data I have in Excel.

I currently have 4 columns of Data, Columns A and F are the values and C and H Barcodes were generated from Columns A and H:

The problem I have is trying to format and mass generate printable Barcode sticker labels from this data, Ideally, I would like it to be laid out like the below while printing:

Is this possible via VBA or another function within Excel?

Thanks

 

[Larry Haydn]

If you are using only Excel to produce these barcodes, then you can do this:

Example:
Cell A1: Insert the barcode text, set the font to Code 39 or Code 128
Cell A2: Insert the same barcode text, set font at any desired human-readable font

Cell D1: Insert the barcode text, set the font to Code 39 or Code 128
Cell D2: Insert the same barcode text, set font at any desired human-readable font

etc.

If you are printing on peel-off labels:
* You will need to format the label and margin size, and insert pagebreaks between each row.

--------------------------------------------------------------------------------------------------
If you use a barcode-generator software, it can generate the barcode plus the text, all in 1 cell.

I use TEC-IT's TBarcode Office to generate thousands of unique barcodes and QR Codes for product labels everyday.
If you are interested, you can check them out at:

Free Online Barcode Generator: Create Barcodes for Free!

This free online barcode generator creates all 1D and 2D barcodes. With TEC-IT Barcode Software you generate barcodes as part of applications or web-sites. Available as Barcode ActiveX, Barcode .NET Web Forms Control, Barcode DLL.

barcode.tec-it.com