tip text for user defined worksheet functions
 

Does anybody know how to have tip text shown for each parameter of
user-defined worksheet functions? For instance, I have the following function
in a module:

Public Function KAK(Ind As Double, Lb As Double, Ub As Double, _
Avr As Double) As Variant
If Avr = 1 Then
KAK = (Log(Ub - Lb) - Log(Ub - Ind)) / Log(Ub - Lb)
ElseIf Avr 0 And Avr < 1 Then
KAK = ((Ub - Lb) ^ (1 - Avr) - (Ub - Ind) ^ (1 - Avr)) _
/ ((Ub - Lb) ^ (1 - Avr))
End If
End Function

I want to display tip texts, so that when the user types "=KAK(" in a cell,
the tip text would display "Indicator" in bold, reminding her of what
parameter is required first, then after the first comma is entered "Lower
bound" would be shown or turn bold, then "Upper bound" and so on.

Thanks in advance for your help!

Rafael

tip text for user defined worksheet functions
 

It isn't really supported for UDF's written in VBA, but look he

http://xcell05.free.fr/

http://www.jkp-ads.com/Articles/RegisterUDF00.htm
http://www.dailydoseofexcel.com/arch...on-with-excel/

--
Regards,
Tom Ogilvy


"Rafael Guerreiro Osorio" wrote:

Does anybody know how to have tip text shown for each parameter of
user-defined worksheet functions? For instance, I have the following function
in a module:

Public Function KAK(Ind As Double, Lb As Double, Ub As Double, _
Avr As Double) As Variant
If Avr = 1 Then
KAK = (Log(Ub - Lb) - Log(Ub - Ind)) / Log(Ub - Lb)
ElseIf Avr 0 And Avr < 1 Then
KAK = ((Ub - Lb) ^ (1 - Avr) - (Ub - Ind) ^ (1 - Avr)) _
/ ((Ub - Lb) ^ (1 - Avr))
End If
End Function

I want to display tip texts, so that when the user types "=KAK(" in a cell,
the tip text would display "Indicator" in bold, reminding her of what
parameter is required first, then after the first comma is entered "Lower
bound" would be shown or turn bold, then "Upper bound" and so on.

Thanks in advance for your help!

Rafael

tip text for user defined worksheet functions
 

Many thanks Tom, having the arguments' description on the Insert Function
dialog for sure will be enough.

Best,

Rafael

"Tom Ogilvy" wrote:

It isn't really supported for UDF's written in VBA, but look he

http://xcell05.free.fr/

http://www.jkp-ads.com/Articles/RegisterUDF00.htm
http://www.dailydoseofexcel.com/arch...on-with-excel/

--
Regards,
Tom Ogilvy


"Rafael Guerreiro Osorio" wrote:

Does anybody know how to have tip text shown for each parameter of
user-defined worksheet functions? For instance, I have the following function
in a module:

Public Function KAK(Ind As Double, Lb As Double, Ub As Double, _
Avr As Double) As Variant
If Avr = 1 Then
KAK = (Log(Ub - Lb) - Log(Ub - Ind)) / Log(Ub - Lb)
ElseIf Avr 0 And Avr < 1 Then
KAK = ((Ub - Lb) ^ (1 - Avr) - (Ub - Ind) ^ (1 - Avr)) _
/ ((Ub - Lb) ^ (1 - Avr))
End If
End Function

I want to display tip texts, so that when the user types "=KAK(" in a cell,
the tip text would display "Indicator" in bold, reminding her of what
parameter is required first, then after the first comma is entered "Lower
bound" would be shown or turn bold, then "Upper bound" and so on.

Thanks in advance for your help!

Rafael