-
-
- 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
-
UnitOfMeasure
Returns or sets the coordinate units used by the following properties: BarHeight and XDimension, PictureWidth, PictureHeight, OutlineWidth, PaddingLeft, PaddingTop, PaddingRight, PaddingBottom
Syntax
BarCodeWiz1.UnitOfMeasure [ = enum]
The settings for enum are:
Value | Description | |
---|---|---|
Unit_HiMetric | 1 HiMetric Unit = 0.001 cm; 1000 HiMetric = 1cm | |
Unit_Mil | Default Setting. 1 Mil = 0.001 inch; 1000 Mil = 1 inch | |
Unit_Twip | 1 Twip = 0.00694 inch; 1440 Twips = 1 inch | |
Unit_Inch | 1 Inch = 2.54 Centimeters = 25.4 Millimeters = 72 Points = 1440 Twips = 1000 Mil = 2540 HiMetric Units | |
Unit_Millimeter | 1 Millimeter = 1/10 Centimeter; 10 Millimeters = 1 Centimeter | |
Unit_Centimeter | 1 Centimeter = .394 Inch; 2.54 Centimeters = 1 Inch | |
Unit_Point | 1 Point = 1/72 inch; 72 Points = 1 Inch | |
Unit_DotAt96dpi | 96 dots per inch. 1 unit = 1/96 inch | |
Unit_DotAt150dpi | 150 dots per inch. 1 unit = 1/150 inch | |
Unit_DotAt203dpi | 203.2 dots per inch. 1 unit = 1/(203.2) inch | |
Unit_DotAt240dpi | 240 dots per inch. 1 unit = 1/240 inch | |
Unit_DotAt300dpi | 300 dots per inch. 1 unit = 1/300 inch | |
Unit_DotAt305dpi | 304.8 dots per inch. 1 unit = 1/(304.8) inch | |
Unit_DotAt400dpi | 400 dots per inch. 1 unit = 1/400 inch | |
Unit_DotAt406dpi | 406.4 dots per inch. 1 unit = 1/(406.4) inch | |
Unit_DotAt480dpi | 480 dots per inch. 1 unit = 1/480 inch | |
Unit_DotAt600dpi | 600 dots per inch. 1 unit = 1/1600 inch | |
Unit_DotAt609dpi | 609.6 dots per inch. 1 unit = 1/(609.6) inch |
When creating barcode for low resolution printers, it's always best to set X Dimension to a value that aligns with the size of the printer dot. This can be done easily by setting UnitOfMeasure to a value with your printer's dots-per-inch resolution. For example:
BarCodeWiz1.UnitOfMeasure = Unit_DotAt203dpi
BarCodeWiz1.XDimension = 4.0 // Set the X Dimension to thickness equal to 4 dots
For displaying barcodes on screen at 96 dots-per-inch:
BarCodeWiz1.UnitOfMeasure = Unit_DotAt96dpi
BarCodeWiz1.XDimension = 2.0 // Set the X Dimension to 2 pixel
BarCodeWiz1.BarHeight = 96.0 // Set Bar Height to 96 pixels (1 inch)
BarCodeWiz1.OutlineWidth = 1.0 // Set width of outline to 1 pixel