Public Function Argument Descriptions

[stilesbn]

With normal functions in excel there is a help bar that tells you what the function arguments are while you are typing it into the formulas bar. For example with the if statement, when you type in "=IF(" you then see the following information:

=IF(logical_test,[value_if_true], [value_if_false])

Is there any way to have a public function written into a macro do this?

Here is the start of a public function I have.

Public Function Agents(SLA As Single, ServiceTime As Integer, CallsPerHour As Single, AHT As Integer) As Long

I would like when I type in "=Agents(" to see

"=Agents(SLA, ServiceTime, CallsPerHour, AHT)"

Any ideas?

 

[RoryA]

No, there isn't, I'm afraid. You can add descriptions for the Function Wizard, but not for the tooltip.