UDF Intellisense

[EssoExplJoe]

How do I get my UDF's to show up like the Excel functions. I want to type in a cell "=Loo" and have the list of functions starting with Loo show my UDF "Look_Horz"?

[EssoExplJoe]

I found my error. The test function I was using didn't set the function return value. Unless you set the function return value, the UDF doesn't show up in the list.

[Logit]

.
Here's a link describing just what you want :
.
.
http://stackoverflow.com/questions/1...e-excel-functi