Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Registering UDFs | Excel Programming | |||
UDFs | Excel Programming | |||
VBA, UDFs and VSTO | Excel Programming | |||
'portable' UDFs??? | Excel Programming | |||
autocompletion of cell input based on databse list | Excel Programming |