The Developer tab is the toolbar that has the buttons to open the VBA editor and create Form Controls like buttons, checkboxes, etc. First, be sure that the Developer tab is visible in the toolbar in Excel. Here is the main part of the Macro, mechArray and activityArray are only small arrays - with 4 and 10 elements each, outArray is around 120x10x2. In VBA it is only one line to get the hex color of a cell background: CStr(Right(00000000 & Hex(), 6)) Copy. You can access the VBA environment in Excel 2011 for Mac by opening the Visual Basic editor. Is there a reason the Mac takes over 1000x longer? If you want Option Explicit automatically in your newly created modules (recommended), then go in the VBA editor to Tools -> Options -> Editor (on Mac: Excel.
I've tried the macro on other Windows computers with lower specs than hers and the macro completes in a few seconds. The macro also works on my workmates Mac but takes much longer between 2000 to 4000 seconds. The macro works well on my Windows computer and completes in under 2 seconds. I wrote a macro for a workmate recently copies the data from an Excel spreadsheet into a 2D array approximately 75000x58 in size, then runs through each row and extracts relevant data.
