Public Function Parameters Explication

[Arvipor]

Hello fellow members of this forum, this is my first time posting a question, but I've been a constant reader of your posts.

I'm currently working on a Min function with a conditional, if you want to check the code it works like a charm... but my problem comes when I try to make it look more professional...

Function MinCond(cnd As Variant, X As Range, Y As Range) As Double
Dim nX As Long
Dim nY As Long
Dim i As Integer
Dim min As Double

nX = UBound(X(), 1)
nY = UBound(Y(), 1)

If nX <> nY Then

MsgBox "Los dos rangos deben ser iguales", vbCritical, "No seas pendejo, pendejo!"
  GoTo error
End If
Do Until X(j, 1) = cnd
j = j + 1
Loop
min = Y(j, 1)
For i = 1 To nX

If min > Y(i, 1) And X(i, 1) = cnd Then
min = Y(i, 1)End If
Next

MinCond = min
error:End Function

If you work with a normal Excel Function you can see a description of the formula...

following the name of the parameters listed...

but when it comes to the public function I created...

nor the name of the parameters...

Do you guys know a way to describe a Public function and/or its parameters?

 

[adam087]

AFAIK the short answer is no, you can't get it to do decent intellisense like that. I think the closest you can get is this...
http://www.mrexcel.com/forum/excel-questions/804518-udf-descriptions.html

Welcome to the board btw

/AJ

 

[Arvipor]

Well this would be helpfull, it's a shame though that Excel desn't have this kind of feature.

Anyway, thank you a lot for your help.

 

[adam087]

No probs

/AJ

 

[shg]

But if you press Ctrl+A immediately after the opening paren, you'll see a list of arguments.