FAQ

Search:

The barcode does not change in serial printing via VBA

I would like to print barcodes in a loop with sequential numbers. On the screen the barcode is always correct, but in the print the serial number is not taken over. What can I do?
It seems the barcode is not updated. This may be a timing issue. You can make Excel to draw a new barcode by simply manipulate it, e.g. the size:

Temp = Barcode1.Width
Barcode1.Width = 10
Barcode1.Width = Temp
Well, this simply reduces the size of the control and the set it back to the original values. This forces Excel to redraw the control, and it is done correct. USe this code directly before your print command.

| Home | Shop | Download | E-Mail | Privacy Policy | Imprint | Version 6.5.0
Copyright ©
Frank HornActiveBarcode Generator
Web design: szBubble 3.1.12.318
Copyright © Frank Horn
&
Lars SchenkActiveBarcode Object
Web- & server component
Command line
Copyright © Lars Schenk

All trademarks and product names mentioned are the property of their respective owners.



We use cookies to provide you with the best experience and functionality on our website. By using our site you agree to this. read more >