Passing arguments from Excel to a UserForm.

[LaShark]

Can anyone provide an example passing an array of values from an excel macro to a UserForm. Can't seem to find anything in the books or help box.

Thanks in advance

 

[Mark O'Brien]

You need to use ByRef to pass arrays. For example, if I've got a function in a standard module that needs a string array as an argument I would declare the function like this:

<pre>
Private Function MyArrayFunction(ByRef sArray() as String)
'...
End Function</pre>

If this Function is on a UserForm or Class Module and you wanted to call them from outside of that module you woud have to declare the function like this:

<pre>
Public Function MyArrayFunction(ByRef sArray() as String)
'...
End Function</pre>

HTH

 

[LaShark]

Thank you!!