Value from the ActiveSheet.PrintOut statement the Zebra printer does not print a barcode but the appearance of the cell itself. With ZebraDesigner Pro v2, you enhance your printer's capabilities and. These themes are offered in a selection of styles and also can be made use of with any type of making program. ZebraDesigner Pro v2 barcode label design software makes creating complex labels based on fixed or variable data simple. However, this gives me an "Run time error 1004 - Application-defined or Object-defined error" (which makes sense because Cell.Value is not an object) and if I remove the. Zebra Printer Label Template Making use of a printable label design template is an easy means to tailor the labels you produce for your business. If Range("E" & r) "" Then 'the r values correspond with row numbersĪctiveSheet.PrintOut copies:=Range("A" & r).Value, collate:=True, IgnorePrintAreas:=False
#Zebra label designer excel mod#
For alternating bands your formula is MOD (ROW (),2) Click the Format button and.
Select 'Use a formula to determine which cells to format' > enter your formula in the 'Edit the Rule Description' field. Printer Network: MSP-Label2 on MPS-DC-001. Information about the label printer: Printer Name: MSP-Label2.
I have done a lot of searching and can not find a solution. It contains a 12-digit number to be printed as a barcode label: Sub ZEBRA_LABEL() On the Home tab of ribbon select Conditional Formatting > New Rule. When I click on the button, the information on the Label tab gets printed to a normal network printer if I forget to switch it to the zebra label printer. This is not designed to work for as soon as the value is inputted, I was just testing to see whether the printer prints a BARCODE which is the most important part of this, so I used the code below which I lifted from here. I am looking for a macro or another way to print labels on a Zebra printer as soon as a value is inputted into a specific column in a spreadsheet. I am very much of a beginner with VBA so forgive any sloppiness.