New: TFORMer Designer V9.2 — easily design and print labels and forms. Explore the product →

TEC-IT

FAQ TBarCode OCX

How Can I Setup ITF-14 via Excel VBA?

How Can I Setup ITF-14 via Excel VBA?

With the following code you can adjust ITF-14 with a bearer bar and a quiet zone.

Me.TBarCode111.BarCode = eBC_ITF14
Me.TBarCode111.QuietZoneUnit = eMUModules
Me.TBarCode111.QuietZoneLeft = 10
Me.TBarCode111.QuietZoneRight = 10
Me.TBarCode111.BearerBarType = eBearerBar_TopAndBottom

Me.TBarCode111.Text = "0123456789123"
Or
Me.TBarCode111.LinkedCell = "A1"

Get coordinates of cell:

With Selection
    X = .Cells(1, 1).Left
    Y = .Cells(1, 1).Top
    MsgBox "X = " < X < vbNewLine < "Y = " < Y
End With

Set the bar code position:

Me.TBarCode111.Left = X
Me.TBarCode111.Top = Y

Make every label, code and scan work the first time.

Try it free in the browser, download a full trial, or talk to sales about your systems, standards and volume.

Get started Contact Sales →

Online Inquiry

Write an e-mail instead

For support or sales: edit your message and send it yourself. Sales enquiries are forwarded internally. Recipient: support@tec-it.com

Incomplete transfer: only first name, last name and e-mail can currently be copied. Other answers, full trial licence keys and files are not copied. Add your question below, omit full licence keys and attach files manually in your mail app.