function variables show on sheet

[terdfurg]

I am new to VBA and I hope I can explain this properly. I wrote a function: isValidISBN and it will show up on the scroll menu if i select a cell and start typing isVa... in the same way that =sum, and =vlookup come up. I was wondering if there was a way to display the needed variables. For example =sumif(range,criteria,[sum_range]). I want the "range,criteria,[sum_range]" equivalents of my function to show. As of now it just says "isValidISBN("
Is there a way to do this in VBA?

[Kenneth Hobs]

No. There are ways to give help for your function as if Fx was pressed.

[terdfurg]

No. There are ways to give help for your function as if Fx was pressed.

Thanks. How is that done?

[Kenneth Hobs]

There are some involved methods that lets you add more help than the more simple method of Applicaton.MacroOptions.

[JKwan]

you could try something like this, type your formula then hit (for example "=sum")
1 - Control A
2 - Control Shift A

Take your pick

[Kenneth Hobs]

As JKwan said, you can use option 2. What you can not do is to add the popup as standard functions like =Sum().

For the help by method 1, add it by Application.MacroOptions.

e.g.
[VBA]Sub AddDesc_DisRangeCountIf()
Application.MacroOptions Macro:="DisRangeCountIf", _
Description:="Used like built-in function,=CountIf" & vbCrLf _
& "DisRange: Contiguous or Discontiguous range." _
& vbCrLf & "sCriteria: A string for the criteria.", _
Category:="Kens Functions"
End Sub

Function DisRangeCountIf(ByVal DisRange As Range, ByVal sCriteria As String)
Dim dblCount As Double
dblCount = 0
For Each cell In DisRange.Cells
dblCount = dblCount + WorksheetFunction.CountIf(cell, sCriteria)
Next
DisRangeCountIf = dblCount
End Function
[/VBA]