how to retreive a object between two spaces in a string

[MeghaJ]

need urgent help

i have textbox on a userform where i need to retreive an object form a string between two spaces

for eg the string is test sample test1 sample1

i need an excel vba code to get sample or test1 from the string in the text box

thanx in advance

[nathansav]

you can use the SPLIT function, an example below

Sub test()

strtest = "test sample test1 sample1"

Dim aSplit() As String

aSplit = Split(strtest, Chr(32))

MsgBox aSplit(0)
MsgBox aSplit(1)
MsgBox aSplit(2)
MsgBox aSplit(3)

End Sub