pass unknown number of parameters to function

[ndm]

Hi,

Just wondering if any one knows a way to pass and enumerate an unknown
number of parameter to a VB function. I want to create a Min/Max functions
that can:
a) take an variable number of parameters
b) determine how many parameter are passed to it
c) loop through parameters

PS. I can't use an array or collection

Any help appreciated
Neil

[Cor Ligthert]

Hi Neil,

I think that ParmamArray is the best answer on your question

From MSDN in the function page what is referenenced in the link bellow.
\\\
Public Function CalcSum(ByVal ParamArray Args() As Double) As Double
Dim I As Integer
CalcSum = 0
If Args.Length <= 0 Then Exit Function ' No arguments passed.
For I = 0 To UBound(Args, 1)
CalcSum += Args(I)
Next I
End Function ' Returns latest value of CalcSum.
The function can be invoked as follows:

Dim ReturnedValue As Double
ReturnedValue = CalcSum(4, 3, 2, 1)
' The function's local variables are assigned the following values:
' Args(0) = 4, Args(1) = 3, and so
on.http://msdn.microsoft.com/library/de...en-us/vblr7/ht
ml/vakeyparamarray.asp

I hope this helps?

Cor

Hi,

Just wondering if any one knows a way to pass and enumerate an unknown
number of parameter to a VB function. I want to create a Min/Max functions
that can:
a) take an variable number of parameters
b) determine how many parameter are passed to it
c) loop through parameters

PS. I can't use an array or collection

Any help appreciated
Neil

[ndm]

Cor,

Just what I needed, thanks a million

Neil

"Cor Ligthert" <no**********@planet.nl> wrote in message
news:O6*************@tk2msftngp13.phx.gbl...

Hi Neil,

I think that ParmamArray is the best answer on your question

From MSDN in the function page what is referenenced in the link bellow.
\\\
Public Function CalcSum(ByVal ParamArray Args() As Double) As Double
Dim I As Integer
CalcSum = 0
If Args.Length <= 0 Then Exit Function ' No arguments passed.
For I = 0 To UBound(Args, 1)
CalcSum += Args(I)
Next I
End Function ' Returns latest value of CalcSum.
The function can be invoked as follows:

Dim ReturnedValue As Double
ReturnedValue = CalcSum(4, 3, 2, 1)
' The function's local variables are assigned the following values:
' Args(0) = 4, Args(1) = 3, and so
on.http://msdn.microsoft.com/library/de...en-us/vblr7/ht ml/vakeyparamarray.asp

I hope this helps?

Cor

Hi,

Just wondering if any one knows a way to pass and enumerate an unknown
number of parameter to a VB function. I want to create a Min/Max functions that can:
a) take an variable number of parameters
b) determine how many parameter are passed to it
c) loop through parameters

PS. I can't use an array or collection

Any help appreciated
Neil

[Kokie]

I Love this Group ;)

K.

"Cor Ligthert" <no**********@planet.nl> wrote in message
news:O6*************@tk2msftngp13.phx.gbl...

Hi Neil,

I think that ParmamArray is the best answer on your question

From MSDN in the function page what is referenenced in the link bellow.
\\\
Public Function CalcSum(ByVal ParamArray Args() As Double) As Double
Dim I As Integer
CalcSum = 0
If Args.Length <= 0 Then Exit Function ' No arguments passed.
For I = 0 To UBound(Args, 1)
CalcSum += Args(I)
Next I
End Function ' Returns latest value of CalcSum.
The function can be invoked as follows:

Dim ReturnedValue As Double
ReturnedValue = CalcSum(4, 3, 2, 1)
' The function's local variables are assigned the following values:
' Args(0) = 4, Args(1) = 3, and so
on.http://msdn.microsoft.com/library/de...en-us/vblr7/ht ml/vakeyparamarray.asp

I hope this helps?

Cor

Hi,

Just wondering if any one knows a way to pass and enumerate an unknown
number of parameter to a VB function. I want to create a Min/Max functions that can:
a) take an variable number of parameters
b) determine how many parameter are passed to it
c) loop through parameters

PS. I can't use an array or collection

Any help appreciated
Neil

[Herfried K. Wagner [MVP]]

* "ndm" <nm*****@northnet.com.au> scripsit:

Just wondering if any one knows a way to pass and enumerate an unknown
number of parameter to a VB function. I want to create a Min/Max functions
that can:
a) take an variable number of parameters
b) determine how many parameter are passed to it
c) loop through parameters

'ParamArray' (Visual Basic .NET)
<URL:http://msdn.microsoft.com/library/en-us/vblr7/html/vakeyParamArray.asp>

9.2.5.4 'ParamArray' Parameters (Visual Basic .NET)
<URL:http://msdn.microsoft.com/library/en-us/vbls7/html/vblrfvbspec7_1_6_4.asp>

Data passed to a method in a paramarray parameter is treated as an array
inside the method.

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://dotnet.mvps.org/dotnet/faqs/>

[Cor Ligthert]

Herfried,

Sometimes your echo is late however a message what is answered 5 hours
before, and where two persons answers that the answer fits, and you than and
give an extra link cannot be the purpose of a newsgroup?

When we all visitors here start answer all messages which are allready
answered, the ones who where looking for an answer on there question where
impossible to find that. (It is always possible to find an extra link you
know).

Or is it that you not on top of that list of most posters what we saw posted
yesterday, I can assure you that that list cannot the right one, you would
be on top for all the post of the last year and not Ken.

Only my thought of course to improve the quality of this newsgroup.

Cor
"> * "ndm" <nm*****@northnet.com.au> scripsit:

Just wondering if any one knows a way to pass and enumerate an unknown
number of parameter to a VB function. I want to create a Min/Max functions that can:
a) take an variable number of parameters
b) determine how many parameter are passed to it
c) loop through parameters
'ParamArray' (Visual Basic .NET)

<URL:http://msdn.microsoft.com/library/en-us/vblr7/html/vakeyParamArray.asp>
9.2.5.4 'ParamArray' Parameters (Visual Basic .NET)
<URL:http://msdn.microsoft.com/library/en...bspec7_1_6_4.a
sp>
Data passed to a method in a paramarray parameter is treated as an array
inside the method.

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://dotnet.mvps.org/dotnet/faqs/>

[Herfried K. Wagner [MVP]]

* "Cor Ligthert" <no**********@planet.nl> scripsit:

Sometimes your echo is late however a message what is answered 5 hours
before, and where two persons answers that the answer fits, and you than and
give an extra link cannot be the purpose of a newsgroup?

I didn't see the links in your post and I think that they are important
in addition to your answer.

Just my 2 Euro cents...

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://dotnet.mvps.org/dotnet/faqs/>

[Cor Ligthert]

Herfried,

I didn't see the links in your post and I think that they are important
in addition to your answer.

I thought that it was that, however sometimes it can be overdone.

The links was not right in my post and I had seen that long before you,
however I have seen so many links which where real much worse, it could be
easy be copied and pasted, therefore I did not correct it this time.

However this kind of messages are to learn for us, and as forever only to
improve our quality.

That interface post was great, a pity you did not answer my message in that.

Cor

[One Handed Man \( OHM - Terry Burns \)]

It's not worth pursuing this point Cor, because its been brought up many
times before and H Continues to do this. My belief ( Although he will deny
this as he has done in the past ) is that he thinks that by having the most
posts he can secure another MVP year.

--

OHM ( Terry Burns )
. . . One-Handed-Man . . .
If U Need My Email ,Ask Me

Time flies when you don't know what you're doing

"Cor Ligthert" <no**********@planet.nl> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...

Herfried,

Sometimes your echo is late however a message what is answered 5 hours
before, and where two persons answers that the answer fits, and you than and give an extra link cannot be the purpose of a newsgroup?

When we all visitors here start answer all messages which are allready
answered, the ones who where looking for an answer on there question where
impossible to find that. (It is always possible to find an extra link you
know).

Or is it that you not on top of that list of most posters what we saw posted yesterday, I can assure you that that list cannot the right one, you would
be on top for all the post of the last year and not Ken.

Only my thought of course to improve the quality of this newsgroup.

Cor
"> * "ndm" <nm*****@northnet.com.au> scripsit:

Just wondering if any one knows a way to pass and enumerate an unknown
number of parameter to a VB function. I want to create a Min/Max functions that can:
a) take an variable number of parameters
b) determine how many parameter are passed to it
c) loop through parameters
'ParamArray' (Visual Basic .NET)

<URL:http://msdn.microsoft.com/library/en-us/vblr7/html/vakeyParamArray.asp>

9.2.5.4 'ParamArray' Parameters (Visual Basic .NET)

<URL:http://msdn.microsoft.com/library/en...bspec7_1_6_4.a sp>

Data passed to a method in a paramarray parameter is treated as an array
inside the method.

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://dotnet.mvps.org/dotnet/faqs/>

[Herfried K. Wagner [MVP]]

* "Cor Ligthert" <no**********@planet.nl> scripsit:

I didn't see the links in your post and I think that they are important
in addition to your answer.

I thought that it was that, however sometimes it can be overdone.

It's not overdone in my opinion.

It's not me, and its not you who define what's "overdone" in this group
and what's not, and what's helpful and what is not helpful. Threads are
here to answer the OP's question, but they are also here to collect
information on a certain topic to make it easier for people to find the
answers in future.

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://dotnet.mvps.org/dotnet/faqs/>

[Cor Ligthert]

Herfried,

I didn't see the links in your post and I think that they are important
in addition to your answer.

I thought that it was that, however sometimes it can be overdone.

It's not overdone in my opinion.

It's not me, who define what's "overdone" in this group

(I removed "and not you")

LOL

Cor