Using excel2003 to make barcode graphics and text tutorial

Development Tools--insert--other controls (development tools general hide open way files--options--Customization options find development tools Add)

1. Add Development tools

Click on "file" → "options" → "Custom Ribbon"; Check the Developer toolbar on the Main tab in the Panel.

2. Insert Barcode

Click Development tools → insert in the main tab, and select the other controls button in the lower-right corner of the ActiveX control bar

3. Select Microsoft Barcode Control 15.0 in the other Controls dialog box that pops up, and click OK when the mouse changes to a cross cursor

Find MIC Barcode Control (slightly different versions)

Draw a piece of area to appear as figure

In A1 enter the barcode bar barcode Properties required to find Linkcell input A1

In the right key Barcode control object Properties

Select 6-code-39 (barcode style is selected according to your needs)

Done

Excel 2003 Making Barcodes:

1, the mouse right click on the menu bar, in the pop-up shortcut menu, select the Control Toolbox. In the Pop-up control toolbar, click More Controls, and then select Microsoft BarCode Control 9.0 in the list.

2. When the mouse pointer turns into a fine cross, drag the mouse over the worksheet to draw a barcode control and adjust its position and size.

3, we can link the barcode control with a cell, in this cell to change the barcode number can be generated after the corresponding bar code, such as the bar code control linked to A1 cell. Enter the barcode number in cell A1, then right-click the barcode control and choose Properties from the shortcut menu that pops up.

4, Pop-up Properties dialog box, the "LinkedCell" property to the right input cell address, here is "A1", you can see its "value" property into A1 cell values.

5, in the above "Properties" window can modify all control properties, but not intuitive. You can also modify properties in the Microsoft BarCode Control 9.0 Properties dialog box. Close the Properties window above, right-click the barcode control again, select Microsoft BarCode Control 9.0 object → properties from the pop-up shortcut menu, and pop the Microsoft BarCode Control 9.0 Properties dialog box to modify its properties as needed. For example, the direction of barcodes, whether the need for validation, and so on.

6. Close the dialog box after completing the property settings. Click the exit Design mode button in the Control Toolbox. This step is important, otherwise the barcode cannot be updated automatically when the barcode number in the A1 cell changes.

Attach some basic concepts

Many kinds of bar code, the common probably more than 20 kinds of code system, including: Code39 code (standard 39 code), Codabar code (KUDBA code), Code25 code (standard 25 code), ITF25 code (cross 25 code), Matrix25 code (Matrix 25 code), Upc-a code, UPC-E Code, EAN-13 code (EAN-13 International Commodity Bar Code), EAN-8 code (EAN-8 International Commodity Bar code), China Post code (a variant of the Matrix 25 code), Code-b code, MSI code, CODE11 code, Code93 Code, ISBN code, ISSN code, Code128 Code (Code128 code, including EAN128 code), Code39ems (EMS-specific 39-yard), such as one-dimensional barcode and PDF417 and other two-dimensional barcode.

At present, the international widely used bar code types are:

EAN, UPC code--commodity barcode, used to uniquely identify a commodity worldwide. The most common thing we have in supermarkets is EAN and UPC barcode.

Among them, EAN code is the world's widely used commodity bar code, has become the basis of electronic data interchange (EDI); UPC codes are mainly used in the United States and Canada;

Code39 code--because it can be used in the form of numbers and letters in the various industries within the management of the widely used

ITF25 code--more application in logistics management

Codebar code--More for blood bank, library and photo gallery business

Another Code93 code, Code128 code and so on.