problem with string functions on another's machine

[clumsycanadian]

Hello,
I wrote a program in VBA which works just fine on mine and my colleagues' machines but for some reason, the program runs into an error when executing any statements using RIGHT or MID string functions on my manager's machine. I do not remember the error message, but I think it was something along the lines of 'unrecognizable function.' I ensured that "Visual Basic for Applications" is referenced. How is it possible that my manager's machine runs into error with these 2 functions? Does anyone have any suggestions or an explanation for this. Thanks in advance.

I should also point out that all the computers here are identical in just about every way and that we are using Excel 2000.

 

[PHV]

Double check the references:
menu Tools -> References ...

Does the project compile properly ?
menu Debug -> Compile VBAProject

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[clumsycanadian]

Thanks for the reply PHV,
I did double check, the references (triple checked actually). As for compiling, that option is not available/enabled when I go to menu Debug. The program I made is just a simple "wizard" using a UserForm that is shown when a button is clicked on a workSheet. Nothing fancy. The string functions that are not working are used in the userForm.