Embed and automate a barcode in a Excel 2016, 2013 document
A short description of how to add a barcode to an Excel document
and link the barcode with a cells content.
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:
Activate "Customize Ribbon" and then activate the option "Developer" inside the main tabs and
then close the option window.
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.
A dialog box appears on the screen:
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:
Code 25, ...
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:
Select "ActiveBarcode-Object" and then "Properties...".
dialog of ActiveBarcode will open. Here you can modify the barcode as
Alternatively you can use the property dialog of Excel. For this use the following
button named "Properties" of the "Controls" range:
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:
Enter the cell's name for the link into this property. That's it!
This manual was created by Frank Horn