-
-
- 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
QuietZone Horizontal/Vertical
Returns or sets the amount clear space around the bar code. Quiet Zone may be required for higher barcode readability.
Quiet Zone is measured in multiples of XDimension.
Syntax
BarCodeWiz1.QuietZoneHorizontal [ = enum]
BarCodeWiz1.QuietZoneVertical [ = enum]
The settings for enum are:
| Value | Description | |
|---|---|---|
| Zone_None | There is no Quiet Zone around the barcode. | |
| Zone_Auto | Horizontal Quiet Zone is set automatically. | |
| Zone_1x | Horizontal Quiet Zone is equal to XDimension. | |
| Zone_2x | Horizontal Quiet Zone is equal to 2 x the value of XDimension. | |
| Zone_3x | Horizontal Quiet Zone is equal to 3 x the value of XDimension. | |
| Zone_4x | Horizontal Quiet Zone is equal to 4 x the value of XDimension. | |
| Zone_5x | Horizontal Quiet Zone is equal to 5 x the value of XDimension. | |
| Zone_6x | Horizontal Quiet Zone is equal to 6 x the value of XDimension. | |
| Zone_7x | Horizontal Quiet Zone is equal to 7 x the value of XDimension. | |
| Zone_8x | Horizontal Quiet Zone is equal to 8 x the value of XDimension. | |
| Zone_9x | Horizontal Quiet Zone is equal to 9 x the value of XDimension. | |
| Zone_10x | Horizontal Quiet Zone is equal to 10 x the value of XDimension. | |
| Zone_11x | Horizontal Quiet Zone is equal to 11 x the value of XDimension. | |
| Zone_12x | Horizontal Quiet Zone is equal to 12 x the value of XDimension. | |
| Zone_13x | Horizontal Quiet Zone is equal to 13 x the value of XDimension. | |
| Zone_14x | Horizontal Quiet Zone is equal to 14 x the value of XDimension. | |
| Zone_15x | Horizontal Quiet Zone is equal to 15 x the value of XDimension. | |
| Zone_16x | Horizontal Quiet Zone is equal to 16 x the value of XDimension. | |
| Zone_17x | Horizontal Quiet Zone is equal to 17 x the value of XDimension. | |
| Zone_18x | Horizontal Quiet Zone is equal to 18 x the value of XDimension. | |
| Zone_19x | Horizontal Quiet Zone is equal to 19 x the value of XDimension. | |
| Zone_20x | Horizontal Quiet Zone is equal to 20 x the value of XDimension. |