Create barcodes with VBA and macros in Microsoft Excel

Use BarCodeWiz Code 128 Fonts functions in your own macros and VBA code.

This macro is equivalent to selecting the cells A1 to A6 and clicking on Selection To Barcodes on the toolbar.

Sub MyMacro()

    Range("A1:A6").Select

    Application.Run ("CODE128_SelectionToBC")

End Sub

 

The following functions are equivalent to clicking on BarCodeWiz toolbar:

Application.Run ("CODE128_Options") -- Opens the Options window.
Application.Run ("CODE128_Sequential") -- Opens the Sequential Number Generator window.
Application.Run ("CODE128_SelectionToBC") -- Converts the selected cells to barcodes.
Application.Run ("CODE128_Labels") -- Opens the Labels wizard to convert selected cells to barcode labels.
Application.Run ("CODE128_Undo") -- Undoes the previous operation.