Mastering Code 128 Barcode Printing in Microsoft Office

Code 128 is the industry standard for high-density linear barcodes. Because it requires a mandatory checksum digit, manual entry isn't possible—but with the Barcodesoft font package, professional printing is seamless.

code128 gs1128 barcode Access database download Download Demo
code128 gs1128 barcode Access database order Order Full Version

Step-by-Step Installation & Integration

1

Install TrueType Fonts

Locate all TrueType Font files (*.ttf) in your download package and copy them to your system directory: C:\Windows\Fonts.

2

Register Font Utility (DLL)

Open the Command Prompt (DOS) as Administrator and execute the following commands to register the encoder component:

# Navigate to directory

CD C:\Program Files (x86)\Common Files\Barcodesoft\FontUtil

# Register DLL

regsvr32 crUFLbcs.dll

code128 barcode

If registration fails, use the .NET utility:
Regtlibv12 _cruflbcs.tlb

3

Configure Microsoft Excel Macros

Launch Excel and adjust security settings to allow the barcode generator to run:

Excel 2000 / 2003 code128 barcode

Set Security to "Low"

Excel 2007+ code128 barcode code128 barcode

Choose "Enable all macros" in Trust Center

4

Initialize Visual Basic Editor

Press ALT + F11 to open the VBA Editor.

code128 barcode

Adding Reference

Go to Tools > References. Click Browse and select cruflbcs.dll (found in C:\Program Files\CommonFiles\Barcodesoft\Fontutil). Ensure the checkbox is checked.

code128 bar code
6

Import Barcodesoft Module

Press Ctrl + M and import barcodesoft.bas.

Missing the file? Download it here: Barcode Software Module

code128 barcode VB
7

Encoding & Formatting Data

You can now use custom formulas to encode your data. Use cell references (e.g., A1) inside the following functions:

  • =Code128A(A1)
  • =Code128B(A1)
  • =Code128C(A1)
  • =uccean128(A1)
code128 barcode macro

Final Step: Apply the Font

Right-click the encoded cell > Format Cell > Font. Select a Barcodesoft typeface like Code128aMHr.

code128 barcode font