I have an array s(0) to s(63).
I want to perform an operation: text1(s(i)).bac kcolor=vbblue.
Now Textbox1 is a control array: text1(0) to text1(63).
I need to pass S(0) to s(63)...all in a function by reference.
I tried it just by putting byref s in the function...but it doesnt work, ie the values of s(0) to s(63) do not change, they remain the same.
Does anybody have a solution to this problem?
I want to perform an operation: text1(s(i)).bac kcolor=vbblue.
Now Textbox1 is a control array: text1(0) to text1(63).
I need to pass S(0) to s(63)...all in a function by reference.
I tried it just by putting byref s in the function...but it doesnt work, ie the values of s(0) to s(63) do not change, they remain the same.
Does anybody have a solution to this problem?
Comment