AUTOCOMPLETION FOR UDFs
 

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.
--
Thanx in advance,
Best Regards,

Faraz

AUTOCOMPLETION FOR UDFs
 

What do you mean by a partially filled cell?

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


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=164981

Microsoft Office Help

AUTOCOMPLETION FOR UDFs
 

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?
--
Thanx in advance,
Best Regards,

Faraz


"joel" wrote:


What do you mean by a partially filled cell?

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


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=164981

Microsoft Office Help

.

AUTOCOMPLETION FOR UDFs
 

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)")


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=164981

Microsoft Office Help