Printing a barcode

[KalvinZ]

Hi everyone,

I have a problem I can’t seem to find an answer to.. I have created a userform for data collection. Each time an entry is made it generates a unique ID (xxx-19000101-1). What I’m trying to accomplish is- turn this ID into a printable barcode, so that when ‘submit’ button is clicked- it would go to a specific printer.. can anyone help please?

 

[felixstraube]

Did you try the some barcode fonts?
like this: Redirecting
?

 

[KalvinZ]

Did you try the some barcode fonts?
like this: Redirecting
?

Hi, thanks for the reply.. this is not really what I’m looking for.. if we forget the barcode part for a moment- could you help with sending the ID number to a specific printer? - directly from the label (lblUDID) when the submit button is clicked?

 

[felixstraube]

Didn't test it myself but this seems to do the job:

Print to a specific Printer using VBA

Hi all, I'm using this code to print a sheet using VBA to a specific printer, called Lexmark E350d: Sub MyPrint() Dim sCurrentPrinter As String Const MyPrinter As String = "Lexmark E350d" sCurrentPrinter = ActivePrinter ActivePrinter = MyPrinter ActiveSheet.PrintOut '

www.mrexcel.com