-
-
- 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
VerticalBarTextEntry
VerticalBarTextEntry allows for entering of TopText and BottomText by setting the Barcode value in the format Barcode|TopText|BottomText
By setting this property to True, it's possible to data-bind the values of text above and below the barcode.
For example, the following sets Barcode value to "123456", TopText value to "Price: $3.50", and BottomText to "Milk 1 gal":
BarCodeWiz1.VerticalBarTextEntry = True
BarCodeWiz1.Barcode = "123456|Price: $3.50|Milk 1 gal"
Syntax
BarCodeWiz1.VerticalBarTextEntry [ = boolean]
The settings for boolean are:
| Value | Description |
|---|---|
| True | Allow Vertical Bar Text Entry mode. |
| False | Default setting. Vertical Bar Text Entry is disabled |