Create barcodes with VBA and macros in Microsoft Excel

Use BarCodeWiz UPC EAN 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 ("UPCEAN_SelectionToBC") 
End Sub                    
                

The following functions are equivalent to clicking on BarCodeWiz toolbar:

  • Application.Run ("UPCEAN_Options") : Opens the Options window.
  • Application.Run ("UPCEAN_Sequential") : Opens the Sequential Number Generator window.
  • Application.Run ("UPCEAN_SelectionToBC") : Converts the selected cells to barcodes.
  • Application.Run ("UPCEAN_Labels") : Opens the Labels Wizard to convert selected cells to barcode labels.
  • Application.Run ("UPCEAN_Undo") : Undoes the previous operation.