Send Textbox Text to Array

[icemail]

Hello,

İ need some help about sendin text or value to array


code is like that

Dim myarray As Variant
myarray = Array(textbox1.text)
For i = LBound(myarray) To UBound(myarray)
'do something
next

thx

[mana]

??

myarray = split(textbox1.text)

[icemail]

??

myarray = split(textbox1.text)

Sub test()

Dim myarray As Variant
'myarray = Array(textbox1.text)
myarray = Split(TextBox1.Text)
For i = LBound(myarray) To UBound(myarray)
msgbox myarray
Next

End Sub

Thanks for reply but showing some error
Runtime error 424
Object required

[Aflatoon]

That error implies you don't have an object called Textbox1.