Help with Array & Split

[Les]

Hello all,

I have a form that has data that the user enters with respect to a part
number, i have a radio button that if the user selects then he can enter
multiple part numbers, seperated by a comma ",". All the other data remains
the same.
What i am trying to do and really battling with is to split the numbers by
"," and then for every number i would like to start a new line and insert all
the data in a spreadsheet. What i had in mind was an array with a split
function, but not sure if i am thinking in the right direction.


Any help would be much appreciated.

 

[Gary''s Student]

You can always input a string variable and create an array from it:

Sub les()
Dim s As String
s = "1,2,3"
ar = Split(s, ",")
End Sub

 

[Les]

Thanks Gary
--
Les

You can always input a string variable and create an array from it:

Sub les()
Dim s As String
s = "1,2,3"
ar = Split(s, ",")
End Sub

 

[Gary''s Student]

You are quite welcome.