Send group of variable to a function

Philosophaie · Nov 8th 2016

In ASP.net you can combine a group a variables as a Class and send them to a function.

How do you do this in a Subroutine transferring it to a Function extracting the data to use in the function?

Code

Sub sendtofn()
     data1=1
     data2=2
     data3=3
     'combine datas
     result = fn1(datas)
End Sub
Function fn1(Byval datas)
     'extract datas to new data1, data2, and data3
     fn1 = result
End Function

Display More

Wigi · Nov 8th 2016

Re: Send group of variable to a function

Not sure if you mean this ?

Code

Sub sendtofn()
    
    Dim datas(1 To 3) As Long
    
    datas(1) = 1
    datas(2) = 2
    datas(3) = 3
    
     'combine datas
    result = fn1(datas)
    
    MsgBox result
    
End Sub
Function fn1(datas() As Long) As Long


     'extract datas to new data1, data2, and data3
    fn1 = WorksheetFunction.Sum(datas)
    
End Function

Display More

Send group of variable to a function

Participate now!

Share

Users Viewing This Thread