How to call subs with 3 or more parameters

[DOM85]

Hi,
In "Sub" example (documentation) i see :
Example:
Sub MySub (FirstName As String, LastName As String, Age As Int, OtherValues() As Double) As Boolean
...
End Sub

But how to call a such sub since the max number of parameters is 2 with callsub3 ?

Thanks

 

[Erel]

You will need to change the sub signature or create another one that will delegate to this sub.
You can use a custom type to pass all the variables:

Type MySubType (FirstName As String, LastName As String, Age As Int, OtherValues() As Double)

And then declare the sub:

Sub MySub (v1 As MySubType)

 

[DOM85]

You will need to change the sub signature or create another one that will delegate to this sub.
You can use a custom type to pass all the variables:

Type MySubType (FirstName As String, LastName As String, Age As Int, OtherValues() As Double)

And then declare the sub:

Sub MySub (v1 As MySubType)

Hi Erel,
Perfect!!
Thank you.

 

[hdtvirl]

How is mySub called.

Thank Erel, for this answer, how is MySub called ?, can you give an example please.

Regards

BOB

 

[Erel]

Dim p As MySubType
'Set p fields
p.FirstName = "aaa"
...
'Direct call
MySub(p)
'With CallSub
CallSub2("component", "MySub", p)

You can also create a sub that returns a type of MySubType (like a constructor) and then the code can be more elegant.

 

[hdtvirl]

Thanks

Erel, that works great, that example sorted a small issue I had, I thought the original problem was created by me through my lack of knowledge and expereince and the original post proved me right I was at fault !!.

Thanks again to DOM85 for asking the original question.

Regards

BOB.

A mistake is always a mistake is nothing is learned from it !!!.