User Defined functions tooltip

can you post your function

CallOption(UnderlyingPrice, ExercisePrice, Time, Interest, Volatility, Dividend). I want tooltip to come if someone types CallOption(. I hope iam clear enough. Ined the yellpw thing to appear.

You can't. (Unless you are using 2010 which I think now has this ability, but I can't be sure offhand)

1) Although it isn't what you asked, you CAN add a description that has this information in it using the ALT-F8 window. Press Alt-F8, type in the name of your function (it probably won't appear in the list), click on OPTIONS and put in your help text.

2) The Intellisense ToolTip that appears while typing in the cell, there is no easy way to do it, it was simply not included in the VBA options.

I have seen a hack that lets you highjack a seldom used function and reorient its intellisense for your function, but it is a hack, and not something I would do.

rakesh5883 said:

I have created my own function in Excel. But, now if someone use that formula in the sheet. I need to get the tooltip which we generally get with formulas like ex : =Average( (we get a yellow tooltip ). How do i make that appear for User Defined Functions.
Please help.

Click to expand...

I've been searching for the answer to that and everything I have found (including from a Microsoft Expert) is that you can't create an actual tooltip at this time -- though Microsoft is talking about making this available.

However, you've been able to create a module description and function description for a long time and this information is shown in the Insert Function and Function Arguments dialog boxes [fx].

To do this part you get into the VBA editor and press F2 for the Object Browser. Select VBAProject from the first dropdown. Then right-click your class(es), select Properties, and enter & save a description for the class. Repeat that process for each member of your class. These are saved as hidden properties in your module (which you can see if you export the module and use Notepad to view the text file).

Then, at least as of Excel 2010, you can now also create argument descriptions and those will also be shown in the Insert Function and Function Arguments dialog boxes [fx]. The following is an example subroutine you can create in your module to describe each member's arguments.