tip text for user defined worksheet functions

  • Thread starter Rafael Guerreiro Osorio
  • Start date
R

Rafael Guerreiro Osorio

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
 
R

Rafael Guerreiro Osorio

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

Best,

Rafael
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

User defined functions that are array functions 1
User-defined type not defined 1
Refreshing user defined functions 3
Application.StatusBar or equivalent for user defined functions 3
User Defined Functions to separate full names 4
User Defined Function being called by changes to an independent workbook 13
Paramters or Argument Auto-Label/Balloon Tip for User-DefinedFunction 1
User Defined Function Help 4

Top