UDF text case

[Zack Barresse]

DennisW wrote in another post:

...When You use it (a UDF) for the first time make sure You enter it with UPPERCASE. In that way Excel will "remember" to show the function with UPPERCASE....

Ok, so obviously this explains some things to me. My question is this: If you enter your UDF in lowercase first, is there a way to change it after you've done it one way? Short of deleting the UDF, starting over and re-entering the UDF in the formula bar?

Just kind of curious.

[Juan Pablo Gonz?lez]

Close Excel and open again.... (having deleted the formula in Excel), if I remember correctly, that shall do it for you.

[Zack Barresse]

Thanks Juan, I'll give it a go!