UDF Naming

[Arun]

This seems to be a nit-picky question, but I need it to make my worksheet
more readable.

How do I get the capital/lowercase sequence of my UDF name to carry over to
my worksheet? For example, I defined a function name as SearchItems(),
however when I type it into my worksheet it shows up as searchitems(). Is it
a requirement that all UDF's appear completely in lower case?

 

[PeterA]

The Function's name should remiain the same in appearance when deployed on the WorkSheet. Check your code to see whether "SearchItems" is so spelled in the declaration (first) line- Function SearchItems() As String.


Peter

 

[Jim Rech]

Is it a requirement that all UDF's appear completely in lower case?

No it is not. However, the way you enter the name the FIRST time is the way
Excel will remember it in that workbook from then on. This has nothing to
do with being the name of a UDF. When you type a name Excel doesn't know it
creates a "name" and remembers its case.

New workbook.
Type ="ABC()
In another cell type =abc()
Excel converts the second to =ABC()

Start with a lower case name and Excel works the reverse way.

--
Jim
| This seems to be a nit-picky question, but I need it to make my worksheet
| more readable.
|
| How do I get the capital/lowercase sequence of my UDF name to carry over
to
| my worksheet? For example, I defined a function name as SearchItems(),
| however when I type it into my worksheet it shows up as searchitems(). Is
it
| a requirement that all UDF's appear completely in lower case?

 

[Arun]

Wow, I can't believe that's how it works... but you're right,

Is there anywhere I can go to see the list of defined names or modify them?
How about clearing one out?

 

[Jim Rech]

I've been able to make Excel forget a name like ABC in my example by
creating a real name ABC and then deleting any formulas that contain it and
then deleting my real ABC. Saving the workbook and restarting Excel between
the last couple steps. I think you'll also see the name looking at the file
with a hex editor. I think you could change the case of ABC with a hex
editor too and that should stick. Hopefully the name is unique so you're
sure you are editing the right place in the file and not some label ABC.

It's easiest to get the name right from the beginning.<g>.

--
Jim
| Wow, I can't believe that's how it works... but you're right,
|
| Is there anywhere I can go to see the list of defined names or modify
them?
| How about clearing one out?
|
| "Jim Rech" wrote:
|
| > >> Is it a requirement that all UDF's appear completely in lower case?
| >
| > No it is not. However, the way you enter the name the FIRST time is the
way
| > Excel will remember it in that workbook from then on. This has nothing
to
| > do with being the name of a UDF. When you type a name Excel doesn't
know it
| > creates a "name" and remembers its case.
| >
| > New workbook.
| > Type ="ABC()
| > In another cell type =abc()
| > Excel converts the second to =ABC()
| >
| > Start with a lower case name and Excel works the reverse way.
| >
| > --
| > Jim
| > | > | This seems to be a nit-picky question, but I need it to make my
worksheet
| > | more readable.
| > |
| > | How do I get the capital/lowercase sequence of my UDF name to carry
over
| > to
| > | my worksheet? For example, I defined a function name as
SearchItems(),
| > | however when I type it into my worksheet it shows up as searchitems().
Is
| > it
| > | a requirement that all UDF's appear completely in lower case?
| >
| >
| >