Azalea Software, Inc.

Printing Code 128 Bar Codes in Excel

Use our Excel plugin to print Code 128 barcodes. This Excel plugin addes the guard bars, calculates the check digit, and maps into our fonts' character set. This plugin supports code set A, code set B, and code set C.

Download AzaleaBarCodes.xla into your XLStart directory (Program Files\Microsoft Office\OFFICE11\XLSTART). Put barcode.dll into either your \WINDOWS\SYSTEM32 or \WINNT\SYSTEM32 directory.

Open your own spreadsheet.

Enter valid data in the cells you want to encode into bar codes. Here, our "input data" column is Column A.

Select B1 or the cell you want to contain the bar code symbol. Type the equal sign "=";.

The available functions drop down list becomes active (black arrow above A1 cell). Note that you also may do this and the following by going to Menu Insert/Function.

Select "More functions". Another window pops up. Choose "User defined" (meaning, in this sample, the list of available functions within your XLStart directory add-in's). Azalea's Code 128 functions appear. Select "AzaleaCode128A", "AzaleaCode128B", or "AzaleaCode128C" depending on which code set you want to use.

Click the OK button.

Pass the function an argument. In this sample, the content of cell A1. Click the OK button.

Select B1. Go to "Format" menu, choose "Cell" then click the "Font" tab. Select a Code 128 font and point size.

To center the bar code, click the "Alignment" tab and choose Center for both horizontal and vertical.

...select Edit/Fill/Down.

Select A1-A4 / B1-B4, File/Print Preview.