-
-
- Install Barcode ActiveX Add-in in Excel
- Barcodes in MS Excel
- Create Sequential Barcode Labels in Excel
- Add Supplemental Text to Barcodes in Excel
- Extract Barcode Images from MS Excel
- Create Dynamic Barcodes Using LinkedCell in Excel
- Supplemental Text in Barcodes Using LinkedCell in Excel
- Barcodes in Excel with VBA
-
-
- BackColor
- BackStyle
- Barcode
- BarcodeColor
- BarcodeTextColor
- BarcodeTextFont
- BarcodeTextVisible
- BarcodeTextPosition
- BarcodeTextStretch
- BarHeight
- BearerBars
- BottomText
- BottomTextAlignment
- BottomTextColor
- BottomTextFont
- BottomTextVisible
- ControlAlignment
- ControlAutosize
- DataMatrixSize
- LinkedCell
- OptionalCheckChar
- Orientation
- OutlineColor
- OutlineStyle
- OutlineVisible
- OutlineWidth
- Padding Left/Top/Right/Bottom
- PDF417Columns
- PDF417ErrorCorrectionLevel
- PDF417RowHeight
- PDF417Truncated
- Picture
- QRCodeErrorCorrectionLevel
- QRCodeSize
- QuietZone Horizontal/Vertical
- Symbology
- TopText
- TopTextAlignment
- TopTextColor
- TopTextFont
- TopTextVisible
- UnitOfMeasure
- VerticalBarTextEntry
- WideToNarrowRatio
- XDimension
-
Barcode ActiveX Control
LinkedCell
Returns or sets the value of LinkedCell.
The LinkedCell property is only available when the control is inserted in an Excel Sheet.
The property binds the value of the Barcode to the value of a specified cell in the spreadsheet. Whenever the value of the cell updates, the barcode does also.
Examples:
BarCodeWiz1.LinkedCell = "A1"
BarCodeWiz1.LinkedCell = "Sheet1!A1"
Syntax
BarCodeWiz1.LinkedCell [ = string]