You can use the Visual Basic split function to convert a comma-separated string to an array. The function allows you to send a string as an IN parameter of a function instead of sending an array. Then the string can be converted into an array using this function.
Here’s an example of using the split function:
Private Function GetArray() as Variant Dim arrParams As Variant arrParams = Split("Test1,Test2,Test3", ",") GetArray=arrParams End Function