Create Dynamic Barcodes Using LinkedCell in Excel

Barcodes in Excel

Barcodes in Word

Barcodes in Access

More Tutorials

User Manual

  • This tutorial shows how to use the LinkedCell property to have your barcode update whenever the source cell changes.

Step 1. Enable Developer Tab

  • Navigate to File -> Options
  • In Excel Options, select Customize Ribbon tab and make sure Developer entry is checked. Click OK.

Step 2. Insert ActiveX Control

  • Click on Developer tab > Insert > ActiveX Controls > More Controls.
  • Select BarCodeWiz Class and click OK.
  • Left-Click onto an empty area in Excel to insert the control.

Step 3. Link Barcode Control to Data Cell

  • Open the Properties window of the control.
  • Set the LinkedCell property to the source cell. For example, A1.
  • The cell is now linked. Changing data in A1 will also update the barcode.