Excel
Barcode objects in a spread sheet

Excel

Embed and automate a barcode in an Excel sheet
Excel 365, 2019, 2016, 2013, 2010

endeesitfr
Info Starting with ActiveBarcode Version 6.20, an Add-In for Excel 2010 or newer is available. This makes working with the barcode object in many application scenarios easier. A step-by-step tutorial for the add-in can be found here.
1

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 in such a way that the "Developer" tab appears. To do this, go to in the Excel Options by clicking the "File" tab. This switches to the Backstage view. Then click on "Options" in the tab group on the left:

Barcode, Excel

2

Under "Customize Ribbon", enable the "Developer" option on the main tabs, then close the options window.

Barcode, Excel

3

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

Barcode, Excel

4

A dialog box appears on the screen:

Barcode, Excel

5

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: QR Code, GS1/EAN-128, Data Matrix, GTIN/EAN-13, Code 39, GS1-Data Matrix, Code 128, PDF417, DUN-14, EAN-8, EAN-14, EAN-18, ISBN, ITF-14, NVE, PZN8, SCC-14, SSCC-18, ...

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

6

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

7

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

8

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

If you want to create a barcode that encodes data from several cells, you must first merge these cells into an helping cell. Then connect this combined cell with the barcode object.

In the following example, the contents of cells B3 and B4 are combined in cell B6. Cell B6 is linked to the barcode object.

Barcode, Excel


| Home | Shop | Download | E-Mail | Privacy Policy | Imprint | Version 6.5.0
Copyright ©
Frank HornActiveBarcode Generator
Web design: szBubble 3.1.12.318
Copyright © Frank Horn
&
Lars SchenkActiveBarcode Object
Web- & server component
Command line
Copyright © Lars Schenk

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



We use cookies to provide you with the best experience and functionality on our website. By using our site you agree to this. read more >