Menu

PDF417 in Microsoft Excel

How to add a PDF417 Barcode ActiveX to a MS Excel sheet



Start the Excel and create a new sheet or open an already existing sheet. Now go to the menu "Insert" and select the "Object..." menu item.

Excel and PDF417 Barcode ActiveX

Then, select the barcode control from the list of available ActiveX Controls

Excel and PDF417 ActiveX

After selecting it, click and drag an area for the control to appear in the spreadsheet. After this you may size the control as necessary. To change the properties of the control such as barcode height, data to encode, compaction mode, and symbology type, click on the Properties button from the Control Toolbox.

Click on the properties button to change the PDF417 ActiveX properties

When you are finished, you may exit design mode by choosing the design mode button that looks like this:
Excel and PDF417 Barcode ActiveX design mode

You must be in design mode to edit the properties of the control. If you have problems editing the properties of the control, press the design mode button to enable it.

To link a cell to the data you want encoded in the barcode, click properties button
Excel and PDF417 Barcode ActiveX design mode

and then enter the cell in the "LinkedCell" property of the control.

Excel and PDF417 Barcode ActiveX linking