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.