AUTOCOMPLETION FOR UDFs

[Faraz A. Qureshi]

Any sample of code which helps in displaying the UDFs in an addin as well
alongwith other formulas when a cell is partially filled?

Looking forward for all your help.

 

[joel]

What do you mean by a partially filled cell?

What language are you writting the Add-In? Can you explain in
little more detail

 

[Faraz A. Qureshi]

Sorry to reply you late Joel!
Actually it was day off due to Christmas yesterday!
However, what I meant was that when you type only "=VL" the excel recognizes
that you are inserting the VLOOKUP function and also gives you the option to
select similar formulas in form of a supertip list.
However, such a feature does not work for a UDF designed in an addin made by
yourself.
How to have your UDF be listed in the same way?

 

[joel]

Did you try the evaluate method. Any worksheet function can be put into
the Evaluate by leaving off the equal sigh)


=sum(A1:B5")


VBA
results = Evaluate("Sum(A1:B5"))


If you have a string in the formula you must in clude the double
quotes

=if(A1="Total",True,False)

VBA
results = Evaluate("If(A1=""Total"",True,False)")