Creating barcodes in Microsoft Office for Mac 2011/2016

ConnectCode Barcode Software includes Open Type barcode fonts that can be used in Microsoft Office for Mac 2011/2016 for creating barcodes. Functionality available in the software encoder e.g. creating check digits, generating start/stop characters, validating inputs and generating barcode output characters are provided as Microsoft Office formulas (Excel/Word formulas).

These formulas are developed in Visual Basic for Applications and are available for downloaded on this web page. They can be used under the terms and conditions of ConnectCode Barcode Software.

Download MS Office 2011 for Mac OS X barcode Formulas - officebarcodeformulas.zip

or

Download MS Office 2011 for macOS barcode Formulas - macOSoffice2011barcodeformulas.zip

or

Download MS Office 2016 for Mac (OS X / macOS) barcode Formulas - officebarcodeaddin.zip

Please note that you will need a registered copy of ConnectCode Barcode Software (available on the Mac App Store) to use these formulas.


Creating barcodes in Excel for Mac 2011/2016

The Office VBA formulas can be imported into Excel to create industry-compliant barcodes within minutes. The steps are illustrated below.

Importing the barcode formulas into Excel for Mac 2011


  • Ensure that you have downloaded the officebarcodeformulas.zip (for OS X) file or macOSoffice2011barcodeformulas.zip (for macOS) file above.

    (Note: If you are using macOS, you can use the macOSoffice2011barcode.xlsm spreadsheet found in the zip file and skip the rest of the steps below.)
  • Uncompress the zip file to locate the Excel formulas (MSOfficeBarcodeFormulas.bas file).
  • Launch Microsoft Excel, create a new Workbook and select the Developer tab.
  • Click on the Editor button to launch the VBA editor.
  • Click on File > Import File (or alternatively Option Command i)
  • Navigate the Import File dialog to choose the MSOfficeBarcodeFormulas.bas file.
  • You will be able to see the formulas imported as Module1 in the Project window as shown below.

  • Click on Excel > Close and Return to Microsoft Excel (or Command Q) to close the VBA editor and return to Excel.
You have successfully imported the formulas to Microsoft Excel.

Importing the barcode formulas into Excel for Mac 2016 (or Office 365)


  • Ensure that you have downloaded the officebarcodeaddin.zip file.
  • Uncompress the zip file to locate the Excel Add In (MacExcelBarcodeAddIn.xlam file).

    (Note: The MacExcelBarcodeSpreadsheet.xlsm is a reference spreadsheet that contains all the barcode formulas. You can use this spreadsheet if you Office 365 does not yet support the use of Native Add In.)
  • Launch Microsoft Excel, create a new Workbook and select the Developer tab. If you do not see the Developer tab, you can go to System Preferences > View to enable it. Please see the options highlighted in red below.

  • In the Developer tab, click on the Add-Ins button. Next, click on the Browse button and select the MacExcelBarcodeAddIn.xlam file.

  • Click on the OK button to return to Excel.
You have successfully imported the formulas to Microsoft Excel by adding the Add In.

Generating barcodes in Excel for Mac


  • Enter the value "123456" into cell A1 of the spreadsheet as shown below.
  • Enter the formula "=Encode_Code39(A1)" into cell B1 of the spreadsheet and press then enter/return key. The complete list of formulas can be found in the PDF documentation of the downloaded zip file.
  • Notice the value "*123456L*" generated in cell B1. The formula validates the input in cell A1, adds the start/stop characters "*", and generates the check character "L".
  • Select cell B1 and click on the Home tab. In the ribbon Font group, select "CCode39_S3" as the font and "24" as the font size.

Note : You will need to install a registered copy of ConnectCode Barcode Software and setup the barcode fonts on your Mac before you can use the "CCode39_S3" font in Microsoft Excel.

Back to Barcode Software for Mac page.

news & events  

08 13 2014 Barcode & Label
Barcode & Label is a label design and barcode printing app for the Windows Store. read more
01 26 2012 Finance Toolkit is now Universal
Finance Toolkit is now universal with support for the iPhone4, iPhone4S, iPad, iPad2 and iPod Touch (4th generation). read more
07 20 2011 Finance Toolkit for iPad
Finance Toolkit is a comprehensive suite of touch-based investment spreadsheets and modeling templates developed by ConnectCode. Equipped with over 50 financial templates in many different categories of finance, it significantly improves the productivity of investors and analysts on financial calculation, modeling and analysis. read more
04 27 2011 Barcode Software for Mac
A highly acclaimed barcode software that uses Open Type fonts to create industry compliant barcodes. read more
03 25 2011 Free Barcode Software for Mac
This is a free barcode software that uses Open Type fonts to create Code 39, Industrial 2 of 5 and POSTNET barcodes. read more
12 15 2008 ConnectCode Animator Preview
This is a preview release with the automatic animation effects generation and the fully integrated Designer tool. read more
Read all news

newsletter

Please enter your e-mail to subscribe to our newsletter