Barcode for .NET Suite
How to Generate Barcodes in Excel using VB.NET
How to print, embed barcode images in Excel worksheets using VB.NET
Excel Barcode Integration > Barcode in VB.NET
KA.Barcode for .NET Suite is an outstanding barcode generator control SDK, which can help developers easily generate high-quality barcodes in Microsoft Excel Workbook, create barcodes in Microsoft Word Document, stream barcodes in ASP.NET web application, paint barcode images in Windows Forms, as well as C# & VB.NET Class & Console applications, etc.
To generate barcodes in Excel with no programming skills or fonts needed, you can view the tutorial for KA.Barcode for Excel generator addin/plugin here.
Compatibility & Requirements

Development Environments

  • For Visual studio 2005/2008/2010
  • Visual C#, Visual Basic.NET, Borland Delphi and more

OS Compatibility:

  • Operating Systems with Microsoft .NET Framework 2.0 or above
Test Environment:
  • Microsoft Windows XP
  • Microsoft Visual Studio 2008
  • Visual Basic.NET
  • Microsoft Office Excel 2007
Download Barcode Library for Free
Start generating barcode in Excel by downloading the generator free trial package!

Install Control & Add Reference

  1. 1.
    Unzip the SDK to find "KeepAutomation.Barcode.Windows.dll" and "KeepAutomation.Barcode.Web.dll"
  2. 2.
    Click "Project" and select "Add Reference..."
  3. 3.
    In the popup window, please click "Browse" to locate either one of the above two dlls and then click "OK"
  4. 4.
    Now the control has been added to your project reference successfully
How to Generate Barcodes in Excel Using VB.NET
  1. 1.
    In Visual Studio, click File, and then create a new project "Excel Workbook"
  2. 2.
    Drag a PictureBox from the left-side Toolbox, and drop into the created Excel
  3. 3.
    Double click the picture box, and you will get a form1 for programming
  4. 4.
    Copy the Visual Basic.NET sample code below to insert a barcode in the Excel workbook
  5. 5.
    Debug the project and you will see the barcode image in the Excel
  6. 6.
    Note: Please make sure you have installed the MS Excel version supported by your VS
Private Sub pictureBox1_Click(sender As Object, e As EventArgs)
Dim barcode As New BarCode()

barcode.CodeToEncode = "123456789"
barcode.Symbology = KeepAutomation.Barcode.Symbology.Code39
barcode.ChecksumEnabled = True
barcode.DPI = 72
barcode.X = 2
barcode.Y = 60
barcode.LeftMargin = 10
barcode.RightMargin = 10
barcode.Orientation = KeepAutomation.Barcode.Orientation.Degree0

Dim bmp As Bitmap = barcode.drawBarcode()

Me.pictureBox1.Image = bmp
Me.pictureBox1.Refresh()


End Sub