Version 5.56 \|

FAQ: Excel

Search:

Excel: How do I use ActiveBarcode control with Excel?

To add a barcode to your sheet, select "Insert" from the main menu and select the menu item "Object". A dialog box containg a list of controls opens. Select "ActiveBarcode" here and click OK. A barcode will be created into your document.
To change the barcode, click directly into the barcode with the right button of your mouse. You must be in design mode to do this. Now a pop up menu display and you select "Properties" (for the property dialog of Excel) or "ActiveBarcode/Properties" (for the property dialog of ActiveBarcode). There you can adjust the barcode.

No modification possible: I try to change the barcode but nothing happens! I can't even move or resize it. Whats wrong?

To change the barcode you must be in design mode. Use this button:

to switch to design mode. Then you'll be able to change the barcode by clicking the barcode with the right mouse button.

Lines too thin: I have 4 barcodes objects in my Excel sheet. One of the barcodes is printed with too thin lines. What can I do to solve this?

This problem appears with some systems, when using several barcode objects in one Excel sheet. This is a problem of Excel with objects and is stronger with a low printing resolution than with a high printing resolution. Should this appear, can solve this by using the "Printfix" property of the ActiveBarcode control. Set the "Printfix" property of the problematic barcode to "true". Then the lines are drawn thicker.

Macro: Adding the control: How can I create the barcode control using a VBA macro? For example to place a barcode on a document.

Use the following code to create a barcode at the cursors position:

 Set ab = Selection.InlineShapes.AddOLEObject(ClassType:="BARCODE.BarcodeCtrl.1",
          FileName:="", LinkToFile:=False, DisplayAsIcon:=False)

To access the standard properties, you can use the variable ab now:
e.g. ab.width=200

To access the controls properties and methods, you have to do the following:

 With ab.OLEFormat
      .Activate
      Set abobject = .Object
 End With
 abobject.Text = "987698769812"

Now you can access the properties using the abobject variable.

You did not find an answer to your question?

Do you want to see the German language FAQ which can contain other helpful hints? Click here.

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

ActiveBarcode:

Barcode OCX and Software
The complete solution for all popular barcode types
www.ActiveBarcode.com