VBA Code to Create a Barcode in Excel

VBA Code:

' VBA Code to Create a Barcode in Excel
' This code creates a barcode using a barcode font in a specified cell

Sub CreateBarcode()
    Dim targetCell As Range
    
    ' Set the target cell where the barcode will be created
    Set targetCell = Range("A1") ' Replace with your target cell
    
    ' Clear the target cell contents
    targetCell.ClearContents
    
    ' Set the barcode font name and size
    targetCell.Font.Name = "Code128" ' Replace with your barcode font name
    targetCell.Font.Size = 24 ' Replace with your desired font size
    
    ' Enter the barcode value in the target cell
    targetCell.Value = "123456789" ' Replace with your desired barcode value
End Sub


Check All VBA Codes

Join Our Telegram Group techguruplus telegram group Join Our WhatsApp Group techguruplus whatsapp group

Leave a Comment