DIsplaying Help with Functions 1

[MyFlight]

Is there a way to Display Help when uing the Insert Function (Shift + F3) for Functions I have Created?
Example

Function WhatFontColorIndex(rng As Range)
' Select the Cell with the FONT Color you want Translated
WhatFontColorIndex = rng.Font.ColorIndex
End Function

How would I display ot the End-User the information after the Single quote.

Your assistance will be greatly appreciated.

 

[PHV]

You may try this:
Application.MacroOptions Macro:="WhatFontColorIndex", Description:="Select the Cell with the FONT Color you want Translated"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[combo]

.. or, without vba, display object browser, select your vba project, select your function under 'members' section and right-click the function name. After 'Properties...' you can add or change the description.
BTW, in a similar way description can be added to procedures, modules or other vba components. In case of vba project the description available from vbe menu).

combo

 

[MyFlight]

I found the Function: under Object Browser and Module 2 and WhatInteriorColorIndex.
After I add the Text and save the Workbook (Personal.xls) The text never appears.
Am I forgetting something do I need to change the Help Context ID or something?
Your assistance will be greatly appreciated.

 

[combo]

If you add the description to your function, it should appear at the bottom of the object browser, together with other short information.
The description in excel interface in opposite to built-in functions, is displayed in the formula wizard only.

combo

 

[SkipVought]

I have a desktop and a laptop.

On both I get run time error 1004 on MacroOptions.

Only on the laptop can I manually add help text, because I must not have the proper permissions on the desktop.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}