Thread: inline function help?

I am writing some VB macros in Excel 2007 (VB 6.5). In the Excel window, if I type in a conventional function (=MIN, =MAX, etc.) the tool will begin to auto-complete the list of functions. My functions also appear in this list (good so far). However, when I double click on the function name I would like to get a similar help dialog that I would get with the included Excel functions. For example, when double clicking on MIN a little comment containing MIN(number1, [number2], ...) pops up to let the user know what arguments are required and in what order. I would like a similar feature for the functions that I'm creating. Is this possible?

Thanks guys, I have implemented the code and got it working. However, I would like to future-proof myself by using the Excel2010 ArguementDescriptions option in Application.MacroOptions. My problem is that I get a compile error with the code below. I am looking at compiler directives (change if/else/end to # statements) but can't figure out a way to get the Excel Version prior to compile. Any thoughts?

Public Sub ApplyDescription(FuncName As String, FuncDesc As String, Category As String, ParamArray ArgDesc() As Variant)
   If (Val(Application.Version) >= 14) Then
     Application.MacroOptions _
       Macro:=FuncName, _
       Description:=FuncDesc, _
       Category:=Category
   Else
     Application.MacroOptions _
       Macro:=FuncName, _
       Description:=FuncDesc, _
       Category:=Category, _
       ArgumentDescriptions:=ArgDesc
   End If
End Sub

Perhaps it is new to Excel 2010?
http://blogs.msdn.com/b/excel/archiv...19/482826.aspx

I think there is some confusion. I have fully resolved my original question and am wondering about compile time directives (can I get the Excel version number). I will start a new thread.

Thanks for everyone's help!