Excel User Defined Functions

[amusmani]

Hi,

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.

 

[pilotError]

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.

 

[balamw]

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

Or request that the mods move the thread there for you. I left a link from the programming forum just in case.

B

 

[MisterMe]

Hi,

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.

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.