Error ParamArray

[sisan]

Hi, all. I have a problem here

I wrote a procedure with parameters, using ParamArray to pass variative number of parameters, and it is exactly same as the sample in MSDN.

Sub AddLists(ByVal TheKey As String, ByVal ParamArray NamaFields() As String)
...
...
End Sub

But as I leave the Sub sentence, VB tell me with the error:
Compile error:
Expected: identifier

and the word ParamArray blocked.

Help me please, I need to do so. What's wrong with it ?

 

[JohnYingling]

Param array can not be ByVal and must be As Variant

ParamArray NamaFields()

"ParamArray Optional. Used only as the last argument in arglist to indicate that the final argument is an Optional array of Variant elements. The ParamArray keyword allows you to provide an arbitrary number of arguments. ParamArray can't be used with ByVal, ByRef, or Optional. "

http://www.VBResizer.com

Forms/Controls Resizing/Tabbing Control

http://www.VBCompare.com

Compare Code (Text)

http://www.VBSortGen.com

Generate Sort Class in VB or VBScript

 

[sisan]

Thanx, Yingling!

I've update my prog and it worked. But why MSDN wrote the 'wrong' sample code ?

thanx again.

 

[sisan]

Sorry, I submitted this thread twice at once. But I really didn't mean it.

Special thanx for Sunaj, too. You gave me the sample code.

Thanks for you all again.