ActiveX Controls For Dynamic Barcode Cells

IDAutomation's ActiveX Barcode Controls may be used in Excel on Windows systems. The Licensed or Demo version may be dragged, dropped, and sized on a spreadsheet. This control can only be linked to one cell. If an entire column of cells should be linked, consider using barcode fonts as an alternative.

  1. In Microsoft Excel, on the Developers Tab, click Insert, and under the ActiveX Controls section, click on the More Controls icon.
    Add More Controls
  2. Select the barcode control from the list of available ActiveX Controls. Select the control that was installed starting with "IDAutomation," and drop it onto the spreadsheet.
    Select the IDAutomation Linear Barcode ActiveX Control.
  3. Draw the image for the control to appear in the spreadsheet as if it were a graphic image.
    Place The ActiveX Barcode Control into The Spreadsheet
  4. Size the ActiveX Control as necessary. To modify properties such as barcode height and symbology type, right-click on the control and select properties.
    Right-Click The Control and Select Properties to Modify The Barcode
  5. To link a cell to the data that will be encoded in the barcode, enter the cell location in the "LinkedCell" property of the control. To link an entire column of cells into one barcode, consider using barcode fonts as an option.
    Enter The Cell Location in The LinkedCell Property of The Control
  6. You are finished! Exit design mode by selecting the design mode icon:
    Design Mode Icon of The ActiveX Control
  7. Print and scan the barcode(s) to verify that the correct data is encoded. If a scanner is needed to verify barcodes, consider the IDAutomation USB Barcode Scanner.

Note: Design mode must be used to edit the properties of the control. If problems are encountered when editing the control properties, select the Design Mode icon to enable it. Be sure to print and scan the barcode(s) to verify the correct data is encoded. If a scanner is needed to verify barcodes, consider one of these USB Barcode Scanners.