Excel 2010
Barcode objects in a spread sheet

Excel 2013
Excel 2010
Excel 2007
Excel 97-2003
VBA Examples
FR French
ES Spanish
IT Italian

Embed and automate a barcode in a Excel 2010 document

A short description of how to add a barcode to an Excel document and link the barcode with a cells content.

First launch Excel and create a new document or open an already existing document.

Make sure that you have configured your Excel, that the "Developer" tab is shown in the ribbon. If not, go to the Excel Options: Click here on the tab "File". With it you change to the preventer view. Then click on "options" on the left:

Barcode, Excel 2010

Activate "Customize Ribbon" and then activate the option "Developer" inside the main tabs and then close the option window.

Barcode, Excel 2010

Now you can embed the ActiveBarcode control element into your Document. Select Developer tab. Click on the button "Insert" from the range of "ActiveX Controls" and then select "More controls" there.

Barcode, Excel 2010

A dialog box appears on the screen:

Barcode, Excel 2010

Select "ActiveBarcode" now and click "Ok". Now a barcode will be created inside your document. This will be a standard barcode of EAN-128 type. This is the default type. You can change this to any barcode type supported by ActiveBarcode: For example: Code 25 Interleaved, Code 39, Code 128, Data Matrix, EAN-8, EAN-13, EAN-18, EAN 128, GS1-128, GS1-Data Matrix, GTIN-8, GTIN-12, GTIN-13, Bookland, ITF-14, PDF417, QR Code, SCC-14, SSCC-18, UCC-128, UPC-A, UPC-E.

Now you can modify this barcode. You can change the type, text, colors etc. For this click inside the barcode with the right mouse button. A pop up menu will open: 

Barcode, Excel 2010

Select "ActiveBarcode-Object" and then "Properties...". The property dialog of ActiveBarcode will open. Here you can modify the barcode as you like.

Alternatively you can use the property dialog of Excel. For this use the following button named "Properties" of the "Controls" range:

Barcode, Excel 2010

Create a link between a cell and the barcode: Open the property dialog of Excel as described above. Now activate the barcode object by clicking onto it once. The property dialog will now display all the properties of the barcode object. Have a look for the property named "LinkedCell". This allows a link between a cell and the barcode:

Barcode, Excel 2010

Enter the cell's name for the link into this property. That's it!

Info The ActiveBarcode Control is 32bit and can be used with the 32bit (x86) version of Office 2010/2013 only. Microsoft itself recommends to install the 32bit (x86) instead of the 64bit (x64) version of the Office package. This is valid, even if you use a 64bit (x64) operating system.

This manual was created by Frank Horn


Info Read more descriptions of how to add barcodes to standard applications, e.g. Office, Excel, Word, Access forms, Access reports, PowerPoint, Visio, OpenOffice.org, Publisher, Freehand MX, Image Editors, WordPad, etc.


Index
Examples
Barcode types
Control / OCX
Application
Internet/ASP/PHP
Licences

rss Twitter Facebook
| Home | Shop | Email | Datenschutz | Sitemap | Version 5.60 | Web Design | Lars Schenk & Frank Horn

All trademarks and product names mentioned are the property of their respective owners.