Excel User Defined Functions

Discussion in 'Mac Apps and Mac App Store' started by amusmani, Oct 22, 2011.

  1. amusmani macrumors newbie

    Oct 22, 2011

    I am having problems using an excel sheet that has a lot of VBA code and contains user defined functions. I have MS Office 2011 so the VBA is supposed to work. The workbook and functions works perfectly with a windows computer but when I use it on my Mac "VALUE" just shows up the cell.

    Excel recognizes that the function exists and also lists the inputs for the function but it cannot evaluate it. I would appreciate any advice.
  2. pilotError macrumors 68020


    Apr 12, 2006
    Long Island
    One of the members of the Mac Office team frequents this site. Search for Mac Office and you should be able to find her user id. I'm not sure if she follows the programming threads though.

    You may have to post in the "Mac Applications" group to catch their attention.

    Or... Wait long enough, I'm sure someone here has Excel for Mac experience.
  3. balamw Moderator


    Staff Member

    Aug 16, 2005
    New England
    Or request that the mods move the thread there for you. ;) I left a link from the programming forum just in case.

  4. MisterMe macrumors G4


    Jul 17, 2002
    We would have to see the code to diagnose the error. One thing to look out for is that the code may explicitly assume the Windows file system. MacOS X does not use the Windows file system. Also, VBA on the Mac does not have the run of the System. It is sandboxed to Office 2011.

Share This Page