Hi,
I have a Userform created with VBA code in Excel 2003 (Windows. Sorry, I don't know the VB version). I've run this code through Excel 2010 (Windows) and it seems to work fine. When I try and run it in Excel for Mac 2004(VB 11.5), I get a "Sub or Function not defined" error, highlighting a call to the 'Replace' function.
This suggested to me it wasn't able to use all VB functions properly, so with a bit of Googling, I tried looking at Tools > References in the VB editor. There were some things in here called VB project and VB converter which were unchecked but when I try to select these and save the changes i get an error: "name conflicts with existing module, project or library" error.
Can anyone help with this?? Or at least help me better understand what the References options actually do.
Many thanks,
Pat
I have a Userform created with VBA code in Excel 2003 (Windows. Sorry, I don't know the VB version). I've run this code through Excel 2010 (Windows) and it seems to work fine. When I try and run it in Excel for Mac 2004(VB 11.5), I get a "Sub or Function not defined" error, highlighting a call to the 'Replace' function.
This suggested to me it wasn't able to use all VB functions properly, so with a bit of Googling, I tried looking at Tools > References in the VB editor. There were some things in here called VB project and VB converter which were unchecked but when I try to select these and save the changes i get an error: "name conflicts with existing module, project or library" error.
Can anyone help with this?? Or at least help me better understand what the References options actually do.
Many thanks,
Pat