11-01-2011, 03:10 PM
I used something like this in one of my code and it worked for me.
This can also be obtained as a return value for function as some one suggested above like:
Another thing is we have to define an array with range definitely before using it.
Hope this helps
Code:
Dim avlprglist(4)
var=GetAvailProgram(searchText,avlprglist)
var=SelectProgram(avlprglist)
FunctionGetAvailProgram(searchText,avlprglist)
....code....
avlprglist=assign the array I created here
End Function
This can also be obtained as a return value for function as some one suggested above like:
Code:
var=yourFunction()
x=newFunction(var)
Function yourFunction()
--code---
yourFunction=assign the array
End Function
Another thing is we have to define an array with range definitely before using it.
Hope this helps