Function Name Mystery !!

[monirg]

Hello;

This maybe a trivial question but I'm curious to know what the experts think ... though it has no impact on the w/b functionality.

I've a UDF in a standard module: (please pay attention to the upper and lower case in the name)

Function MyImSeriesSum(M, X)
'..........my code
 MyImSeriesSum = mysum
End Function

On the w/s, the formula is entered into a cell as:

= MyImSeriesSum(A1, B1)

The formula is displayed on the formula bar as:

= MyIMSeriesSum(A1, B1)

Regardless of how the function name is entered in the formula: MYIMSERIESSUM, myimseriessum, mYiMsErIeSsUm , or whatever, XL insists in displaying the function name in the formula as MyIMSeriesSum no matter what!

If reference to a procedure name is automatically adjusted as far as the case is concerned, then why not displaying the actual Function name MyImSeriesSum ??

I've checked XL Help in case there might be a naming conflict. I couldn't find any.

Can someone please explain ??
Thank you for your insight.

 

[mikerickson]

When you create a UDF, Excel automaticaly capitalizes the spreadsheet formula to match the capitalization of the first time that UDF was entered in a worksheet formula.

Open a new workbook and put this UDF in it

Function MyFtn() as Double
   MyFtn = 4
End Function

enter this formula in a cell =MYFTN()
enter this formula in a different cell =myftn()

The second formula should be changed to =MYFTN()

Open another new workbook and put the same UDF:
enter =MyFtn()
then (in a different cell) enter =myftn()

Spookey, ain't it?

 

[monirg]

Hi;

Very interesting! Thank you for the clarification.

Regards.