-
-
- 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
Symbology
Returns or sets the type of bar code to be used.
Syntax
BarCodeWiz1.Symbology [ = enum]
The settings for enum are:
Constant | Description | Example |
---|---|---|
Code_39 | Commonly used non-retail symbology. Note that the leading and trailing asterisks (*) are added automatically, if not supplied. Characters allowed: 0-9; A-Z; -.$*/+%, and space. | |
Code_39_Extended | Allows all ASCII 128 characters to be encoded by using a double-character format. Most scanners must be switched to the extended mode in order to recognize this. | |
Code_128_A | Allows all ASCII values between 0 and 95. This includes special characters, such as tab or escape. | |
Code_128_B | Allows all ASCII values between 32 and 127. Includes upper and lower case letters. | |
Code_128_C | High density, numeric only symbology. Must have an even number of digits. | |
Code_128_Auto | Default Setting. Allows all 128 ASCII values. | |
GS1_128 | Also known as UCC/EAN-128. Most commonly used in logistics appliations. | |
Interleaved_2of5 | High density, numeric only symbology. Must have an even number of digits. | |
Standard_2of5 | Numeric-only, low density. Commonly used in libraries, blood banks, and parcels. | |
Code_93 | Superset of Code 39. Encodes all ASCII 128 characters. | |
Code_11 | Uses numbers 0-9 and the dash symbol "-" | |
Codabar | Numeric-only symbology. Each bar code, however, must start and end with the letters A,B,C or D. | |
MSI_Plessey | Numeric only symbology used mostly in libraries and retail establishments. | |
UPC_A | Used in retail environments in North America | |
UPC_E | Condensed version of UPC-A. | |
EAN_13 | Used in retail environments outside of North America. | |
EAN_8 | Similar to EAN 13, but EAN 8 numbers are not derived from EAN 13 (as is the case with UPC-E and UPC-A). | |
PostNet | Used by the United States Postal Service | |
RoyalMail | Used by the UK Royal Mail | |
PDF417 | High density 2D Symbology, capable of encoding up to 2710 characters in a single barcode. PDF417 is one of the few symbologies capable of encoding all ASCII 256 characters. | |
DataMatrix | High density 2D matrix symbology capable of encoding up to 3116 characters in a single barcode. | |
Qr_Code | High density 2D symbology capable of encoding up to 7089 characters in a single barcode. |